i have several table and i want for certain login name only can access certain DB
can i restricted like that?
i have several table and i want for certain login name only can access certain DB
can i restricted like that?
yes it can
in EM..
1. double clik the user Logins
2. dont check anything in Server Roles tab,
3. in Database Access Tab, check only the specified DB