1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Ora-01917 user or role 'mdamfa' does not exist

Discussion in 'Server Administration and Options' started by mfahim, Aug 19, 2016.

  1. mfahim

    mfahim Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    pakistan
    dear i want to export data and i try with below code but error ora-01917 create problem for me

    / AS SYSDBA


    SQL> CREATE OR REPLACE DIRECTORY testdir AS 'E:\fulldata\';
    directory TESTDATA created.

    SQL> GRANT READ, WRITE ON DIRECTORY testdir TO mdamfa;

    ora-01917 user or role 'mdamfa' does not exist

    dear again system give me this error
     
  2. Naveen Rachapally

    Naveen Rachapally Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    50
    Location:
    India
    Hi Mfahim,

    ORA-01917 : indicate that the User does not exist.

    try queries dba_users

    select username from dba_users where username='mdamfa';

    It should give the username as result other simply create the user as follows :

    Sql > Create user mdamfa identified xxxx;
    Sql > grant connect,resource,READ, WRITE ON DIRECTORY testdir TO mdamfa;

    Hope this info should help you.