1
vote
2answers
72 views

Configure Oracle user in Enterprise Manager to CREATE VIEW on any of his tables

Is it possible to configure an Oracle user in Enterprise Manager, so that he can later create views on any future, yet unknown table in his schema? I am currently running into "ORA-01031 insufficient ...
0
votes
1answer
206 views

Oracle: how to set only some roles as not default for a user (no GUI)

Scenario: I have instanceA I have instanceB I have USER1 in instanceA I have USER1 in instanceB USER1 in instancA has four roles grante to it: ROLE1 default yes admin_option no ROLE2 default false ...
0
votes
3answers
900 views

Why does “GRANT SELECT … TO Role;” does not allow members of Role to SELECT?

Please consider the following scenario on a Oracle 11g Database. The user ADMIN performs the following: CREATE USER Alice IDENTIFIED BY pwdalice; GRANT CREATE SESSION TO Alice; CREATE ROLE Viewer ...
4
votes
2answers
329 views

Compare two Oracle database roles

I'm trying to re-engineer my corporates user managament and want to compare all the roles with each other to find duplicate ones. Doing it by hand is really tiring and I need to compare like 150 ...
4
votes
3answers
612 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? Can I select all roles ...
2
votes
1answer
303 views

Oracle Packages, Procedures and Functions Not Respecting Roles

When you create a package, sproc or function in one schema (say, SCHEMA1) that accesses objects in another schema (SCHEMA2), even when SCHEMA1 has appropriate permissions to the respective SCHEMA2 ...
7
votes
1answer
335 views

Map Oracle roles to Active Directory groups?

Is there any built-in way to map Oracle database roles to Microsoft Active Directory groups?
8
votes
2answers
44k 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
2k 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 ...
3
votes
3answers
156 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. ...
1
vote
3answers
6k views

When creating views, why do users need direct object permissions if they already have the same permissions via a role?

I'm having a problem with permissions in Oracle 10g. I'm hoping someone can help me make sense of this. I have a schema with a table in it. I have granted select on that table to a role. grant ...
3
votes
2answers
2k views

What is the difference between ROLE and PRIVILEGE for Oracle?

Is role a collection of certain privileges?