Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

System priveleges required to execute package procedure

What system privileges are required to execute the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid,serial#)? I ultimately had to login on the server locally as SYSDBA to execute this package procedure. I was just trying to follow one of your replies to another user using an "underprivileged" userid and getting frustrated.
The only system privilege you need is the ALTER USER system privilege. But even if you sign on as SYSTEM, which has the DBA role that contains the ALTER USER system privilege, you won't be able to execute this procedure. That is because the procedure is owned by SYS and SYS has not granted EXECUTE object privileges on this package to anyone. So you'll either have to sign on as SYS to run this procedure or grant EXECUTE on this to the user you want to run this procedure.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close