Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how can i create a script to know what access all users have in a DB

Status
Not open for further replies.

isonlyme

Programmer
Apr 20, 2002
171
PR
Hi everyone,

Is there a way to create a script that can give you the following?

username,
what database is using,
what role it has,
what access have




thanks in advanced
 
Check out this FAQ

faq962-5411

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
wow thanks perfect,

Aditionally is there a way to view the access that a role have?

I mean for example:

Rolename: RoleSelectOnly
Has:

Select on TABLENAME1
Select on TABLENAME2

etc.

Im a rookie at this sorry and thanks in advanced
 
This thread should have code to view the rights that users and roles have within a database.

thread962-1324602

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top