Database Read-only

When a database is retired and have to be read-only - only allow user to read tables under retired database however how I can grant to new user login into retired database with read-only. It won't me grant new user login. Only exist login id.
Thanks,
Mark
This problem is caused because the database is READ-ONLY. Meaning you can
not insert new users into the SYSUSERS table because it is READ-ONLY. I
might consider putting the database in DBO-USE-ONLY mode and then removing
the READ-ONLY, insert the new user and the place the database back into
READ-ONLY, and then remove the DBO-USE-ONLY usage. This will keep the
database from being update for normal users, but will also lock them out
while you are updating the database.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Mark Call" <anonymous@.discussions.microsoft.com> wrote in message
news:9CCDB045-4AAD-453B-9BAC-24EFC40A976F@.microsoft.com...
> When a database is retired and have to be read-only - only allow user to
read tables under retired database however how I can grant to new user login
into retired database with read-only. It won't me grant new user login. Only
exist login id.
> Thanks,
> Mark
|||Thank you for suggestion.
Thanks,
Mark