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 2005 Forums  SQL Server Administration (2005)  Permissions / audit

Author  Topic  moharils Starting Member 1 Post Posted - 2011-03-04 : 17:09:39 Hi , one of the AD is trying to see if we can have this in mssql 2005 using Each account (application or individual account) has permissions such that it: - cannot see or modify any other users' objects unless explicitly granted access by that object's owner - can create tables, constraints, views, functions, procedures, triggers, indexes (I might be forgetting something here…) - can change its login password - can grant to any other user (application or individual account) access to select/insert/update/delete/execute/modify any objects it owns. ALso there will be another functional account XYZ : - not used by an individuals - those individuals who are a member of XYZ_ROLE (and only those individual accounts) can do create and grant privileges to objects that are owned by XYZ ). Sid sid_m15@yahoo.com