Hi,
I have made a new login, new user (as I have associated my database to login) and new schema.
I need to know what minimum permission I should give to my new login, new user and new schema, so that the person should be able to create tables drop table and perform crud operations on tables, and every thing in programabilty section like sp, views, triggers , udt and functions etc etc. and querying permission viewing permission for system views like for information schema, and sys schema.
Yours sincere