|
Subject:
|
how to create db user?
|
|
Posted By:
|
ram_siddinen
|
Post Date:
|
1/28/2004 3:45:35 PM
|
hi guys,
i need a some info about the sql serve db user.my question is
using the syntax how to create the db users for particular databse
thanks®ards,
RamuSiddineni
|
|
Reply By:
|
bmains
|
Reply Date:
|
1/29/2004 11:53:02 AM
|
You may want to check out the sp_addlogin, the sp_grantdbaccess, and the sp_grantlogin, depending on what you want to do.
|
|
Reply By:
|
ankur_vachhani
|
Reply Date:
|
1/30/2004 5:34:39 AM
|
quote:
Originally posted by ram_siddinen
hi guys,
i need a some info about the sql serve db user.my question is
using the syntax how to create the db users for particular databse
thanks®ards,
RamuSiddineni
they syntax is
SQL > create user user_name identified by passowrd
SQL> grant dba to user_name
|
