In Oracle it is important to note that roles are disabled in PL/SQL run with definer rights. In PL/SQL permissions must be granted directly or invoker rights can be used in the block by adding the phraseAUTHID CURRENT_USER.
About role
Stats
created |
1 year ago |
viewed |
4 times |
active |
10 months ago |
editors |
1 |
Recent Hot Answers
oracle - list users with access to certain tablesDifference between Owned Schemas and Role Membership for Microsoft SQL Server
Problem with permissions for user
Will a SP which writes records fail if accessed by a db_datareader role?
When creating views, why do users need direct object permissions if they already have the same permissions via a role?
more »
Related Tags
oracle × 8sql-server × 7
permissions × 6
privileges × 5
sql-server-2005 × 4
postgresql × 4
users × 3
security × 3
database-administration × 2
stored-procedures × 2
reporting-services
ssrs
sql-server-2008-r2
backup
import
select
sql-server-2008
plsql
restore
microsoft
authorization
view
schema
dba
logins
