Database Administration (MOSC)

MOSC Banner

A couple of scripts for finding a users privileges

BobBeattie
BobBeattie Posts: 4,512 Silver Crown
edited Apr 15, 2009 6:04AM in Database Administration (MOSC) 3 comments

Comments

  • Mark D Powell
    Mark D Powell Posts: 17,366 Rubellite
    I get syntax errors when I try to copy and paste these scripts.  Example in script 2 you select grantor from dba_role_privs which does not have this column.  If I substitute dba_tab_privs the code runs.

    --

    -- Mark D Powell --

    HTH -- Mark D Powell --

  • BobBeattie
    BobBeattie Posts: 4,512 Silver Crown
    I get syntax errors when I try to copy and paste these scripts.  Example in script 2 you select grantor from dba_role_privs which does not have this column.  If I substitute dba_tab_privs the code runs.

    --

    -- Mark D Powell --

    Hi Mark I've been having a lot of trouble getting the document formatted, and had to make several changes. The first try was duplicating lines of code. I'd thought I'd got it all fixed, but obviously not.
    Thanks
    BobB
  • Mark D Powell
    Mark D Powell Posts: 17,366 Rubellite
    Hi Mark I've been having a lot of trouble getting the document formatted, and had to make several changes. The first try was duplicating lines of code. I'd thought I'd got it all fixed, but obviously not.
    Thanks
    BobB
     You are not the first person I have seen make that complaint.  Apparently there are some document creation issues.

    --

    -- Mark D Powell --

    HTH -- Mark D Powell --

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center