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.
| Author |
Topic |
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
 Posted - 2005-07-24 : 21:50:40
|
| I have a database used "abc"I want to assign permissions to this user for all user created stored procedure in my database.How i can do it?Thanksmk_garg |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-24 : 22:02:47
|
| You could probably create a procedure that scans sysobjects or the related INFORMATION_SCHEMA view and assign EXEC permissions to all that match your criteria.There may be an easier way, but that's the way I'd probably do it.Tim |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2005-07-24 : 22:08:20
|
| Thanksanother question is:-how can is see list of all object that has permission to databse user "abc"mk_garg |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-24 : 22:16:45
|
| Look in syspermissions.Do a Grant EXEC ON ... TO and see what goes in there.... |
|
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2005-07-25 : 00:19:28
|
| i used that!Thanks for your help timmymk_garg |
|
|
|
|
|
|
Assign permisssion to stored procedures