October 5, 2005 at 7:47 pm
I need a help , How can I change a User ID and Password for a database in MS sql server.
October 5, 2005 at 8:18 pm
In the EM go to security->login.
October 5, 2005 at 8:41 pm
In the EM , Security , Logins.
what is the function of Database Access Tab.Did I need to check all the listed database, if I did not check, I found that I still able to update and insert data. What is the purpose to check (permit).
October 5, 2005 at 10:28 pm
Database access tabs used to define the database access for current user, so if you have more than 1 database, the user must be specified to access the database, and the role for the user must define too, ie.the user only read to the database.
For example you have DatabaseA and DatabaseB and you have UserA and UserB.
UserA can read and write to database A but only read on databaseB and UserB cannot read databaseA, only have permission to read and write in databaseB, the security setting is For UserA Check the DatabaseA and check the public role and db_datareader and db_datawriter, check DatabaseB and check public and db_datareader.
For UserB, check the DatabaseB and check the public, db_datareader and db_datawriter in the permit database role.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply