Wednesday, March 7, 2012

getting list of users who have access to db

What is the procedure for getting a list of users that have rights to access
a database? I'd like to get a listing back of anyone who has any rights to a
specific db (sorry still learning the backend dbo type commands in sql
server)
also any good articles on security permission settings i could look at to
make sure I am starting to learn these correctly? thanks!Brian,
Do 'sp_helpuser' to get a list of users for the current database.
I also suggest you take a look at this article, especially the security
section.
http://msdn.microsoft.com/library/e..._sp_00_519s.asp
-oj
"Brian Henry" <nospam@.newsgroups.microsoft> wrote in message
news:%23G25XKBpFHA.3408@.tk2msftngp13.phx.gbl...
> What is the procedure for getting a list of users that have rights to
> access a database? I'd like to get a listing back of anyone who has any
> rights to a specific db (sorry still learning the backend dbo type
> commands in sql server)
> also any good articles on security permission settings i could look at to
> make sure I am starting to learn these correctly? thanks!
>

No comments:

Post a Comment