i have a unique requirement where the windows login or SQL login to have permission to the database satisfying following conditions.
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.
Appreciate if anyone can come up with a solution using schema's and roles.
Thank You So much.
View Complete Post