Skip to content

Laurent Schneider

Oracle Certified Master

Tag: role

PLS-00201 in stored procedures

When you grant table access thru a role, you cannot use that role in a stored procedure or view. create role r; create user u1 identified by ***; grant create procedure, create session to u1; create user u2 identified by ***; grant create procedure, create session, r to u2; conn u1/*** create procedure u1.p1 is… Continue reading PLS-00201 in stored procedures

Published October 13, 2014
Categorized as plsql, security Tagged role
Laurent Schneider
Proudly powered by WordPress.