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 |
|
abbikhan
Starting Member
26 Posts |
 Posted - 2011-10-18 : 16:46:41
|
| i wan to create a USER that have permissions only to store procedures that have been created by himself only not by other admin user any one can help... |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-10-18 : 16:48:59
|
| Have you tried using schemas? |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-10-18 : 17:39:24
|
| If you could give more details that would be helpful. |
|
|
|
abbikhan
Starting Member
26 Posts |
Posted - 2011-10-18 : 17:52:24
|
quote:
Originally posted by influent
If you could give more details that would be helpful.
database have 7 sps created by user1 there is another user user2 that should have permissions to execute sps creates by user1 and also able to create new sps, only sps created by user2 should be accessible,viweable, by user2 |
|
|
|
abbikhan
Starting Member
26 Posts |
Posted - 2011-10-18 : 18:07:26
|
| i just created a user owning a rolerole have permission on database Execute,create procedure,select but now i am getting error Msg 2760, Level 16, State 1, Procedure cmdusepro, Line 3The specified schema name "dbo" either does not exist or you do not have permission to use it. |
|
|
|
|
|
|
user access