April 28, 2004 at 4:25 am
in sql server how can i grant only creation of objects right no drop ,no alter.
in creation also if i want only sp creation right.
pls suggest
April 28, 2004 at 5:04 am
Create a stored-procedure that the developer/agent has EXEC permissions to that they can use to pass the properly formed syntax to CREATE TABLE that will check and ensure that they passed a CREATE TABLE statement
This way you can GRANT only SELECT/UPDATE/DELETE permissions to them and still allow them to CREATE TABLE
Good Luck
Good Hunting!
AJ Ahrens
webmaster@kritter.net
April 28, 2004 at 5:19 am
means i will have to create objects for them and there is no way to give only only creation rights to users.
April 28, 2004 at 4:22 pm
Absolutely not!
GRANT EXEC to a sp that is owned by dbo and have the sp run the CREATE TABLE statement.
This way the developers DONT have access and YOU dont have to CREATE TABLE.
The only thing that you need to worry about is the code being passed is CREATE TABLE
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply