Solved

sp_helprotect sp_helpuser WHERE

Posted on 2008-10-17
1
640 Views
Last Modified: 2008-11-12
We have a database.  The users don't have direct access to any of the tables of data.  There are views, functions and procedures with permissions granted to groups, and groups are granted to logins.  

We want to select what views, functions and procedures a user has access to by linking

logins = groups = objects
0
Comment
Question by:bmiller250
1 Comment
 
LVL 26

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 22752319
What you have in SQL server are roles and users are asociated to a role and the roles are granted or denied permissions. Run the sp_helpprotect stored procedures with no parameters and will list all the permissions for all the roles on current database:
EXEC sp_helprotect

Open in new window

0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now