Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get the list of permissions of database object Expand / Collapse
Author
Message
Posted Saturday, September 22, 2007 1:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 12:49 PM
Points: 8, Visits: 25
Comments posted to this topic are about the item Get the list of permissions of database object


Kindest Regards,

Deepthi Viswanathan Nair

Post #401452
Posted Tuesday, December 11, 2007 11:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 2, 2008 9:07 PM
Points: 2, Visits: 16
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
Post #431953
Posted Wednesday, January 23, 2008 2:19 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134
hi deepti,
i too got same like prasanna.any modifiactions to be done?

thx
sreejith
MCAD
Post #446633
Posted Thursday, March 27, 2008 3:15 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 2:42 PM
Points: 89, Visits: 748
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.
Post #475765
Posted Monday, October 27, 2008 4:43 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 29, 2014 11:30 AM
Points: 317, Visits: 522
Hi Deepthi

I need to list all the granular level permission of a user defined database roles. What do I do?

Post #592529
Posted Thursday, December 19, 2013 8:17 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 596, Visits: 753
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?
Post #1524613
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse