Tagged Questions
-4
votes
2answers
66 views
Creating an admin user in Oracle
How can I create a "root" (like on MySQL) in Oracle?
I installed Oracle database on my system, for homework, for school (faculty) but it didn't give me the option to make a root user. Well at least I ...
2
votes
1answer
56 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 ...
1
vote
2answers
851 views
“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?
Earlier I created a user :
SQL>create user suhail identified by password
SQL>User created.
SQL>Grant create session,create table to suhail;
SQL>Grant Succeeded.
but when I login as ...
1
vote
1answer
123 views
ORA-16000 when trying to perform select on read only access ORACLE database
My application's SQL encounters ORA-16000 when trying to access read only Oracle Database
ORA-16000: database open for read-only access ORA-06512: at "SYS.XMLTYPE",
line 272 ORA-06512: at line 1 ### ...
0
votes
1answer
242 views
ORA-00990 error while trying to grant priviliges: Why is that? [closed]
After creating a user named suhail I am trying to grant that user some privileges. But I am getting an error saying missing or invalid privilege . Why is that ?
C:\Windows\system32>SQLPLUS / AS ...
1
vote
1answer
54 views
In Oracle, will certain users only be able to see certain data in the privileges tables?
I can view data in the table_privileges view logged in as a particular user, but it seems to be missing or different information when logged in as a different user.
For the privileges views (data ...
0
votes
1answer
110 views
Oracle create user with privileges to grant references
I want to create an Oracle user who can grant references to other users.
Do I need to make him sysdba for that, or is there any other way?
3
votes
1answer
853 views
How to connect multiple users/schemas in Oracle 11g?
I'm almost new user to databases, so I think I'm doing something wrong.
I have the database created.
I created 3 users, 1 it's an Admin, 2 are just users.
I created 2 roles, 1 for the Admin and 2 ...
7
votes
2answers
19k 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
2answers
326 views
Is to possible to forbid access to tables in own schema - Oracle?
Lets assume that we have the following situation:
We have an Oracle schema/user: USER_TEST (with the "create session" privilege).
SYS as SYSDBA creates couple Tables on schema USER_TEST. Is it ...
3
votes
1answer
547 views
minimum privileges required for a user
I am configuring a 10g Express database on Windows 2003 that will be the back end for a public web server. There are many other things to do to harden the database but a good place to start is user ...
0
votes
1answer
553 views
ORA-01031 Insufficient Privileges Raised From Within Function
When I run a CREATE USER statement within Sql Developer, the user is created just fine. When I try to call a function which performs CREATE USER (followed by a bunch of other statements) I get the ...
1
vote
1answer
2k views
Oracle SQL create view privileges
This is more of a theoritical question but I need help ASAP. Here it is:
With the appropriate use of SQL queries, grant as system
administrators the required access privileges to a database user ...
2
votes
1answer
1k views
Oracle permission issue
Please see the following statements. My question is, the table t1 was created in the users tablespace, so it will take up some space. But why it can be created before I impose the quota on the users ...
1
vote
1answer
769 views
ADMINISTER DATABASE TRIGGER privilege
What does ADMINISTER DATABASE TRIGGER privilege actually mean?
I have the following case:
I have 2 databases: DB1 and DB2
On DB1 I have a trigger which arises after logon on database and checks if ...
2
votes
1answer
103 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
2answers
3k views
What is the best way of checking the current user privileges on a particular table from another schema?
In my software, at runtime, I need to check if the connected user has the privileges on some tables, across 2 different schemas.
From what I found doing research, I came across these 2 views
...
3
votes
2answers
2k views
What is the difference between ROLE and PRIVILEGE for Oracle?
Is role a collection of certain privileges?
