lsrep17 Documentation
lsrep17
User databases
AdventureWorks
Tables
Views
Programmability
Storage
Security
Users
piotrkononow
Roles
Schemas
Project
>
lsrep17
>
User databases
>
AdventureWorks
> Security >
Users
> piotrkononow
piotrkononow
Properties
Property
Value
Type
SqlUser
Login Name
piotrkononow
Default Schema
dbo
Database Level Permissions
Type
Action
CONNECT
Grant
SQL Script
IF
NOT
EXISTS
(
SELECT
*
FROM
master.dbo.syslogins
WHERE
loginname
=
N
'piotrkononow'
)
CREATE
LOGIN
[piotrkononow]
WITH
PASSWORD
=
'password'
GO
CREATE
USER
[piotrkononow]
FOR
LOGIN
[piotrkononow]
GO