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 |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2001-08-13 : 13:21:34
|
| I am having a problem with permissions on stored procs. I recently migrated a database from SQL Server 6.5 to SQL Server 2k and the owner of all the objects is my ID. I wish another ID to have execute permission on all stored procs in the database. I am the db_owner. whats happening is when the new ID tries to execute any proc i get an error saying the stored procedure can not be found. i have explicitly granted execute permission for that ID on that proc and the procedure definately exists. Any clues?Thanks Christian-=:SpasmatiK:=-Edited by - Cyclonik on 08/13/2001 13:28:26 |
|
|
|
|
|
Stored Proc Permissions