Tagged Questions
2
votes
1answer
67 views
Do roles have an owner in oracle?
Suppose that i have logged in to oracle database using user X. then user X creates some roles using create role command. I want to know that is user X the owner of the roles? and can i select all ...
8
votes
2answers
22k views
oracle - list users with access to certain tables
I'm sure this has been asked before but I can't seem to find the relevant details for the following.
Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it ...
2
votes
3answers
1k views
Oracle “Import from Export Files” screen refusing both SYSADMIN and Normal users
I have just installed Oracle 11g on Win64, and I want to import some .dmp files.
I am trying with the tool Oracle Enterprise Manager 11g:
If I log in with SYS as SYSADMIN, and go to Import from ...
2
votes
1answer
107 views
Are there any tables that I can get all Oracle supported system privileges and object privileges?
Are there any tables that I can get all Oracle supported system privileges and object privileges? I know there is a view called all_sys_privs in Oracle. But I can't find more information about it.
...
3
votes
2answers
2k views
What is the difference between ROLE and PRIVILEGE for Oracle?
Is role a collection of certain privileges?
