Grant Role/Grant Privilege
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Grant Role/Grant Privilege

  1. #1
    Join Date
    Jul 2007
    Location
    India
    Posts
    21

    Grant Role/Grant Privilege

    While Creating the following trigger at "Scott" User I've got an error as follows:

    create or replace trigger data_logon_trigger
    after logon
    ON DATABASE
    begin
    execute immediate
    'alter session set nls_date_format = ''yyyymmdd'' ';
    end;
    /

    ERROR at line 3:
    ORA-01031: insufficient privileges

    I've given the following Grants to Scott
    Grant Create Trigger to Scott
    Grant Alter Any Trigger to Scott

    After Above also I've got the same error Later I've given the following:
    Grant DBA to Scott
    Still I've got the same error, later I've given the following Grant:
    Grant Administer Database Trigger to Scott
    Then I can able to create the trigger.

    By Default "Administer Database Trigger" is a Privelege is part of DBA role
    Even If I 've granted that role to Scott, then why it is not able to created that trigger ...........?
    Can u please explain problem might be what..?

    Thanks in advance..
    Giri K.Y.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    logon on schema is what you want

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width