issue sp_helprotect
sp_helprotect, T-SQL
if i give sp_helprotect on one table. it shows the list of access few tables permissions including given table.can i know why it is happens
Question
sp_helprotect, T-SQL
if i give sp_helprotect on one table. it shows the list of access few tables permissions including given table.can i know why it is happens
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
If you are passing the procedure a table name it should give you back a single row for each user and each right granted to the table. Can you post the code that you are running?
Browse more Questions and Answers on Database and SQL Server.
Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Mrdenny | Mar 6 2008 6:45AM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
BrianFerry | May 8 2008 3:03PM GMT
I would look at new enterprise security reporter that includes very powerful sql security reporting abilities.
The tool is avialable from: <a href="http://www.scriptlogic.com/products/enterprisesecurityreporter/sql" rel="nofollow">http://www.scriptlogic.com/products/enterprisesecurityreporter/sql</a>
You will be able to create customizable reports on security of objects and schemas, role membership, database users and server logins.
