Permissions on Extended Stored Procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Permissions on Extended Stored Procedures

Author

Topic

Rithika
Starting Member

2 Posts

Posted - 2007-05-15 : 12:02:14

Hi,

I wanted to check all the users have permissions on the extended and system stored procedures in SQL Server. Is there any way I could find out with some script. Thanks

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-15 : 12:16:01

[code]USE master
GO

sp_helprotect @username = 'user1'[/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Rithika
Starting Member

2 Posts

Posted - 2007-05-15 : 12:46:15

quote:
Originally posted by Rithika

Hi,

I wanted to check all the users have permissions on the extended and system stored procedures in SQL Server. Is there any way I could find out with some script. Thanks

Thank u

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources