Oracle PL/SQL Scripting when running a pl/sql script all roles will get disabled. so if a user normally has create table priv, when running a pl/sql script, the script will not be able to create a table. test by:
then create table by hand to see if you get permission denied. reenable the roles by
now give create table prevs directly to the user
PS/SQL Packages and Procedures 1.NOT ONLY GIVE YOU THE LIST OF OBJECTS BUT TO SEE THE SOURCE TEXT ITSELF:
2.TO SEE IN YOUR USER BY LINE OF YOUR SOURCE TEXT:
3.TO SEE ONLY LOCAL LIST WITH DETAILS:
|