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 |
|
Balage_Baju
Starting Member
8 Posts |
 Posted - 2009-07-13 : 23:48:38
|
| Hi,We are using SQL Server 2005 and we have a requirement to access a database with the following scenerios.1. Users/Groups should be able to create/drop/alter/execute Stored Procedures.2. Users/Groups should be able to do all DML operations in table (Insert/Update/Delete/Truncate) and Select 3. Users/Groups should not be able to do any DDL operations (Create tables/Alter tables/Drop tables)Please provide your inputs to acheive this using T-SQL or GUI.Thanks,Balaji. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-14 : 07:50:32
|
quote:
Originally posted by Balage_Baju
Hi,We are using SQL Server 2005 and we have a requirement to access a database with the following scenerios.1. Users/Groups should be able to create/drop/alter/execute Stored Procedures.2. Users/Groups should be able to do all DML operations in table (Insert/Update/Delete/Truncate) and Select 3. Users/Groups should not be able to do any DDL operations (Create tables/Alter tables/Drop tables)Please provide your inputs to acheive this using T-SQL or GUI.Thanks,Balaji.
BOL |
 |
|
|
|
|
|
Preventing Drop/Create permissions in SQL2005