User :
User is used to access the database and its objects
Adding Users
Adaptive Server requires a two-step process to add a user: sp_addlogin followed by sp_adduser.
to check the database user list need to enter the below command
use <DB_NAME>
go
sp_helpuser
go
sp_adduser stored procedure is used to add the users in the database .
Here iam going to add SAPSR3 user in CL1 database .
No comments:
Post a Comment