user vs schema vs ???
Hi;
I'm new to Oracle but have lots of experience with Sql Server.
I am trying to understand something. Is a user and a schema the same thing? So the user HR is the schema HR and the user defines what schema to use?
In that case (which I think is correct) how does the following work:
1) I want 3 different users for the HR database, one who can update it, one who can only view it, and one who cannot view salaries. How do I set that up?
2) There are users who have sysadmin rights on the entire database. Is this a setting for a user/schema or are there users who are not a schema?
3) Is there a way to tie a user to a Windows group. So all members of the Active Directory HUMAN_RESOURCES group have read-only access on the HR schema?
thanks - dave