ITASM\AIPublic
(local)
>
mdb
>
Users
> ITASM\AIPublic
Properties
Database Level Permissions
SQL Script
Used By
Properties
Property
Value
Type
WindowsUser
Login Name
ITASM\AIPublic
Database Level Permissions
Type
Action
CONNECT
Grant
SQL Script
IF
NOT
EXISTS
(
SELECT
*
FROM
master.dbo.syslogins
WHERE
loginname
=
N
'ITASM\AIPublic'
)
CREATE
LOGIN
[ITASM\AIPublic]
FROM
WINDOWS
GO
CREATE
USER
[ITASM\AIPublic]
FOR
LOGIN
[ITASM\AIPublic]
GO
GRANT
CONNECT
TO
[ITASM\AIPublic]
Used By
db_datareader
db_datawriter