aiUser
(local)
>
CAAMDB_EXAMPLE
>
Users
> aiUser
Properties
Database Level Permissions
SQL Script
Uses
Used By
Properties
Property
Value
Type
SqlUser
Default Schema
aiUser
Database Level Permissions
Type
Action
CONNECT
Grant
SQL Script
IF
NOT
EXISTS
(
SELECT
*
FROM
master.dbo.syslogins
WHERE
loginname
=
N
'aiUser'
)
EXEC
sp_addlogin
N
'aiUser'
,
'p@ssw0rd'
GO
EXEC
sp_grantdbaccess
N
'aiUser'
GO
Uses
aiUser
Used By
db_datareader