A couple of scripts for finding a users privileges

BobBeattie
Posts: 4,512 Silver Crown
Comments
-
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 --
0 -
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.
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.--
-- Mark D Powell --
Thanks
BobB
0 -
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.
You are not the first person I have seen make that complaint. Apparently there are some document creation issues.
Thanks
BobB--
-- Mark D Powell --
HTH -- Mark D Powell --
0