?
Solved

does the following grant gives export, import into, from dump file privilege

Posted on 2009-04-08
5
Medium Priority
?
647 Views
Last Modified: 2013-12-18
Hi

Does the following command
grant create session to xyz_user
give by default export into dump file as well importing from dump file privileges.
what are the privileges this command grants by default apart from creating session.
 Please clarify. Any links, resources, ideas highly appreicated,. Thanks in advance
0
Comment
Question by:gudii9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 20

Expert Comment

by:flow01
ID: 24100267
0
 
LVL 7

Author Comment

by:gudii9
ID: 24102651
for create session they have not explained well about default privileges.  Please advise
0
 
LVL 2

Assisted Solution

by:chuchyyy
chuchyyy earned 200 total points
ID: 24105591
The most important privilege when you grant this is that the user will be allowed to connect to a certain database. Oracle throws a ORA-01045 if this privilege is missing.
0
 
LVL 20

Accepted Solution

by:
flow01 earned 1800 total points
ID: 24117663
reality does not match the description in the link I gave.

In our environment
create session is a system privilege
and connect is a role
  that has to system privileges : create session and alter session

Check for yourself in your own environment:

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Apr 10 19:49:09 2009
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> CREATE USER NEWUSER IDENTIFIED BY EXPERTS;

User created.

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'NEWUSER';

no rows selected

SQL> GRANT CREATE SESSION TO NEWUSER;

Grant succeeded.

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'NEWUSER';

PRIVILEGE
----------------------------------------
CREATE SESSION

SQL> REVOKE CREATE SESSION FROM NEWUSER;

Revoke succeeded.

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'NEWUSER';

no rows selected

SQL> GRANT CONNECT TO NEWUSER;

Grant succeeded.

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'NEWUSER';

no rows selected

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'CONNECT';

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'CREATE SESSION';

no rows selected

SQL> select granted_rolE from dba_role_privs where grantee = 'NEWUSER'
  2  /

GRANTED_ROLE
------------------------------
CONNECT

SQL> drop user NEWUSER;

User dropped.

SQL>
0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31568135
Thank you very much.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question