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 |
|
opowell
Starting Member
12 Posts |
 Posted - 2009-10-09 : 09:20:21
|
SQL Server 2000 SP4Window 2003R2I know this will be simple for someone. I have a user, we will call him X. He is the owner of a database and all the Stored Procs. Now all of a sudden user X can not see the stored procs within the database. However any other user can use the same stored proc, that actual owner has.Q: How can I determine why the user X who is the owner of the DB not use the see the stored procs. Is there a view on premissions by object? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-09 : 14:10:04
|
| seems like a permission issue. what does error suggest? |
 |
|
|
opowell
Starting Member
12 Posts |
Posted - 2009-10-12 : 11:42:53
|
| Find the error. Somceone had given the user evelated premissions, once the user had exceute only, it fixed the issue |
|
|
|
|
|
|
UserId can not see object