Database Security Products (MOSC)

MOSC Banner

Problem executing functions in sys.xs_data_security when code compiled in package or function - ORA-

edited Apr 11, 2019 2:07PM in Database Security Products (MOSC) 7 commentsAnswered

I'm getting the following error message when i try to run a function within the sys.xs_data_security package. I can run the code within a begin-end section, but when the same code is compiled into a function or package I'm getting errors when trying to execute the code.

ORA-01031: insufficient privileges

ORA-06512: at "SYS.XS_SECURITY_CLASS", line 33

ORA-06512: at "SYS.XS_ADMIN_INT", line 151

ORA-06512: at "SYS.XS_SECURITY_CLASS", line 20

ORA-06512: at "FK_DWH_SECURITY.RAS_DVH", line 293

ORA-06512: at line 9

At line 293 in the FK_DWH_SECURITY.RAS_DVH package there is a call to sys.xs_security_class.create_security_class. This call is embedded into a function in the package.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center