Determining Current Role at Runtime

If you experience unexpected privilege errors with a role that was granted appropriate privileges, make sure that the role was enabled during runtime. To obtain this information while you are connected to the database, you can use the onstat -g sql or onstat -g ses command, or you can call the CURRENT_ROLE( ) function or the DEFAULT_ROLE( ) function of SQL.