March 19, 2010 at 1:28 pm
Hi:
I'm create a role with an specific objects like tables, views and SP's.
But i want to know what i'd put in there... just to confirm that all my objects where inserted correctly.
how can i see the onjects inserted to my role?:w00t:
Thanks a lot!!!
March 19, 2010 at 4:27 pm
I just uploaded a script to my blog that can help you with this.
Check it out at http://jasonbrimhall.info/?p=391
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 4:28 pm
Otherwise, you could use the GUI and open the role in the desired database to view it's properties. Then select "securables."
This should display permissions for specific objects for the role - if granted explicitly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 5:35 pm
I try the last one you write, on the porperties and select securetables, but... there's nothing in there.
So i'm going to run the scripts, i told you the result.
THANKS...:w00t:
March 19, 2010 at 5:41 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply