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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Access to Database Objects

Author  Topic  arooncom Starting Member 1 Post Posted - 2010-08-18 : 21:15:53 Folks i need help. I have a unique requirement. The SQL login or Windows login should have following permissions. 1) Should not be able to alter the existing tables under DBO schema. 2) Should be able to INS / UPD / DEL / SEL data in all tables ( DBO Schema or TMP schema ) 3) Should be able to create tables using TMP schema only. ( New schema name is TMP ) 4) Should be able to create stored procedures, functions, views using DBO and TMP schema. Can you please generate a script using schema, roles and logins ? Appreciate your reply Arun