> I cannot find a reference on this for SQL7. All read > only references I see refer to read-only-ing the > database with no reference to how a database could > be read-only for one login and not read-only for > another login. > > A reference please?
For your read-only login, assign the db_datareader role to the login, and nothing else. For your writeable login, assign db_datareader and db_datawriter. If the read-only login also needs to run specific stored procedures, you'll need to grant permissions for those as well, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
