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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2007-03-15 : 07:47:39
|
| Hi pals,I want to create a user in sql server 2000 and i need to give onlyINSERT,UPDATE,DELETE,SELECT,CREATE VIEW,CREATE PROCEDURE,ALTER PROCEDURE,DEBUG PROCEDURE,EXECUTE PROCEDURE permissions. i dont want give Administrative priviliges. He should not be able to alter table structures/drop tables.In SQL server 2005 ihave the concept of DDL triggers so that i can track and restrict whatever suspcious activities (dropping columns,changing datatypes) being done by the database users.But in SQl Server 2000, what i can do i want restrict the users. to I need this.can any one me help me out.Regards,franky |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-15 : 07:55:57
|
| DDL_AdminDATA_READER, DATA_WRITERPeter LarssonHelsingborg, Sweden |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2007-03-16 : 05:43:59
|
| Hi,But DDL_Admin role allows alter on table,create table etc... but i dont want to give create table or alter table privilege to the user.Regards,franky |
|
|
|
|
|
|
|
|
user administration ...