May 29, 2008 at 7:54 am
We are two DBA s working and my other DBA gave dbo execute permissions (securables) for database role. As I said he added securables and gave dbo execute permissions for stored procedure so that one with this permission could execute any stored procedure within that dbo schema. Problem I have is, I cant see those securables even though I am a sysadmin. Anyone has an idea of what could be wrong, I tried a lot but nothing worked, any help would be gr88..
thanks in advance
May 29, 2008 at 8:26 am
Securables are objects. It's not clear what you mean by "permissions (securables)"
It sounds like your other DBA gave permissions to execute all stored procedures. That doesn't have anything to do with what you "see". How are you determining that you can't see something?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 29, 2008 at 8:34 am
It sounds like he granted EXECUTE rights against the dbo schema. If so, you'll need to check the permissions on the schema itself. If you are using SQL Server Management Studio you can view the permissions by checking the dbo schema (in the schemas folder which is in the security folder for the given database). If you're trying to use a stored procedure, make sure you aren't using sp_helprotect. It is legacy from SQL Server 2000 and only returns permissions that SQL Server 2000 handled, meaning it doesn't handle securables like schemas. You can do a search online to see how to return permissions via T-SQL, it's not a simple thing any longer.
K. Brian Kelley
@kbriankelley
May 29, 2008 at 9:22 am
thanks a lottt.... this solves my problem... 😀 have a gr8 day
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply