sankarnarayanan.s
SSC Rookie
Points: 43
More actions
February 13, 2008 at 5:06 am
#76901
My 1st question.
I want to Create User for Particular Database.
How can I create New user?
2nd Question
How to get the User names List?
Andras Belokosztolszki
SSC-Insane
Points: 22031
February 13, 2008 at 5:12 am
#777754
sankarnarayanan.s (2/13/2008)My 1st question.I want to Create User for Particular Database.How can I create New user?2nd QuestionHow to get the User names List?
sankarnarayanan.s (2/13/2008)
On SQL Server 2000 use sp_adduser (see http://technet.microsoft.com/en-us/library/ms181422.aspx)
On SQl Server 2005 use CREATE USER (see http://msdn2.microsoft.com/en-us/library/ms173463.aspx)
On SQL Server 2000:
select name from sysusers
On SQL Server 2005:
select name
from sys.database_principals
where type = 'U'
Regards,
Andras
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply