| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2008-11-20 : 10:34:08
|
| sir , I want to make user who have create , update , delete , select Table BUTnever update stored procedure and views and function .How can i do this ....................Yaman |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-11-20 : 10:49:03
|
Sir I read yesterday ,But i can not get solution of my problem . Bcoz Owner of the database has a power to update table and other things .But i want to a user who can't update & create stored procedure but update & create & delete tables data & structure .quote:
Originally posted by visakh16
GRANT only reqd permissions to userhttp://doc.ddart.net/mssql/sql70/ga-gz_4.htm
Yaman |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-20 : 10:51:10
|
| you want to restrict editing of procedures by dbo? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-20 : 10:51:41
|
| Then don't give Alter permission on SP,Views and function as simple as it is. |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-11-20 : 11:27:28
|
quote:
Originally posted by visakh16
you want to restrict editing of procedures by dbo?
yes sirYaman |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-11-20 : 11:36:02
|
quote:
Originally posted by sodeep
Then don't give Alter permission on SP,Views and function as simple as it is.
It is possible to give permission to owner.Yaman |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-11-20 : 11:52:04
|
quote:
Originally posted by yaman
quote:
Originally posted by sodeep
Then don't give Alter permission on SP,Views and function as simple as it is.
It is possible to give permission to owner.Yaman
I am using this command to restrict Ownerdeny create PROCEDURE TO sa1Yaman |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-20 : 12:10:25
|
| Then what is the purpose of making user DBowner? Revoke his permission. |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-11-20 : 12:12:22
|
quote:
Originally posted by yaman
[quote]Originally posted by visakh16
you want to restrict editing of procedures by dbo?
I am using this command to restrict Owner"deny create PROCEDURE TO sa1"but this is not don .what command command i run ?Yaman |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-20 : 12:17:54
|
| My question is:Why can't you replace owner of database to Sysadmin and remove him from db_owner and give him necessary rights he needs to?Are you getting it? |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-11-20 : 12:37:09
|
| yes sir i am getting your point ./but sir what command i run to stoop alter & create procedure to userYaman |
|
|
|
|
How to grant Permission