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)  Help with Security

Author  Topic  argate7 Starting Member 7 Posts Posted - 2009-04-13 : 05:14:01 Hi, i need some help from you. I need to do..."User management must be applied with one user having administrator rights and another with read only rights. Add at least one additional user to demonstrate roles and security management in SQL Server 2005" How this could be implemented? create user admin for login admin with default_schema = dbaccessadmin create user guest for login guest with default_schema = dbdatareader create user sup for login sup with default_schema = db_securityadmin Are these right?and if not, where is the problem?