Friday, 25 May 2012

Can a role be used to define privileges to access database objects of another schema in procedures and functions? | PL SQL

 Database objects of another schema cannot be accessed in a procedure or function through roles; however, explicit privileges have to be granted to the user for those database objects.