• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 733
  • Last Modified:

sp_helprotect sp_helpuser WHERE

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
bmiller250
Asked:
bmiller250
1 Solution
 
ZberteocCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now