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