September 22, 2007 at 1:05 pm
Comments posted to this topic are about the item Get the list of permissions of database object
Deepthi Viswanathan Nair
December 11, 2007 at 11:16 am
Hi,
I cannot execute this statement.
sp_helpprotect is not found in the docs.
I get this msg on 2000 and 2005.
sp_helprotect 'KROLL_DELTEKCP.PS_DETAIL'
Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346
There are no matching rows on which to report.
Prasanna
January 23, 2008 at 2:19 pm
hi deepti,
i too got same like prasanna.any modifiactions to be done?
thx
sreejith
MCAD
March 27, 2008 at 3:15 pm
Executed : exec sp_helprotect 'dbo.profiler'
Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291
There are no matching rows on which to report."
Conclusion : What is this ?
Note : I could exec sp_helprotect, with out any errors.
October 27, 2008 at 4:43 pm
Hi Deepthi
I need to list all the granular level permission of a user defined database roles. What do I do?
December 19, 2013 at 8:17 am
sayfrend (3/27/2008)
Executed : exec sp_helprotect 'dbo.profiler'Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291
There are no matching rows on which to report."
Conclusion : What is this ?
Note : I could exec sp_helprotect, with out any errors.
For the record, you get that error if there are no permissions defined for the object. I also noticed if the object has no permissions defined but the schema does, you still get the above error.
I've actually found Red Gate's SQL Source Control to be a better option for viewing object permissions, since it gives you the GRANT statements you would execute.
Tony
------------------------------------
Are you suggesting coconuts migrate?
May 12, 2016 at 7:47 am
Thanks for the script.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy