troubleshooting Question

orace parameter to use

Avatar of marrowyung
marrowyung asked on
Oracle Database
13 Comments1 Solution55 ViewsLast Modified:
hi,

for the following Oracle command:

(.*)ALTER SYSTEM(.*)AUDIT_SYS_OPERATIONS(.*)
(.*)ALTER SYSTEM(.*)AUDIT_TRAIL(.*)
(.*)ALTER SYSTEM(.*)OS_ROLES(.*)
(.*)ALTER SYSTEM(.*)REMOTE_LISTENER(.*)
(.*)ALTER SYSTEM(.*)REMOTE_LOGIN_PASSWORDFILE(.*)
(.*)ALTER SYSTEM(.*)REMOTE_OS_AUTHENT(.*)
(.*)ALTER SYSTEM(.*)REMOTE_OS_ROLES(.*)
(.*)ALTER SYSTEM(.*)UTIL_FILE_DIR(.*)
(.*)ALTER SYSTEM(.*)SEC_CASE_SENSITIVE_LOGON(.*)
(.*)ALTER SYSTEM(.*)SEC_MAX_FAILED_LOGIN_ATTEMPTS(.*)
(.*)ALTER SYSTEM(.*)SEC_PROTOCOL_ERROR_FURTHER_ACTION(.*)
(.*)ALTER SYSTEM(.*)SEC_PROTOCOL_ERROR_TRACE_ACTION(.*)
(.*)ALTER SYSTEM(.*)SQL92_SECURITY(.*)
(.*)ALTER SYSTEM(.*)_trace_files_public(.*)
(.*)GRANT(.*)TO(.*)PUBLIC(.*)
(.*)GRANT(.*)SELECT_ANY_DICTIONARY(.*)
(.*)GRANT(.*)SELECT ANY TABLE(.*)
(.*)GRANT(.*)AUDIT SYSTEM(.*)
(.*)GRANT(.*)EXEMPT ACCESS POLICY(.*)
(.*)GRANT(.*)BECOME USER(.*)
(.*)GRANT(.*)CREATE PROCEDURE(.*)
(.*)GRANT(.*)ALTER SYSTEM(.*)
(.*)GRANT(.*)CREATE ANY LIBRARY(.*)
(.*)GRANT(.*)CREATE LIBRARY(.*)
(.*)GRANT(.*)GRANT ANY OBJECT PRIVILEGE(.*)
(.*)GRANT(.*)GRANT ANY ROLE(.*)
(.*)GRANT(.*)GRANT ANY PRIVILEGE(.*)
(.*)GRANT(.*)DELETE_CATALOG_ROLE(.*)
(.*)GRANT(.*)SELECT_CATALOG_ROLE(.*)
(.*)GRANT(.*)EXECUTE_CATALOG_ROLE(.*)
(.*)GRANT(.*)DBA(.*)
(.*)GRANT(.*)ALL ON AUD$(.*)
(.*)GRANT(.*)ALL ON USER_HISTORY$(.*)
(.*)GRANT(.*)ALL ON LINK$(.*)
(.*)GRANT(.*)ALL ON SYS.USER$(.*)
(.*)GRANT(.*)ALL ON DBA_(.*)
(.*)GRANT(.*)ALL ON SYS.SCHEDULER$_CREDENTIAL(.*)
(.*)SELECT(.*)SYS.USER$MIG(.*)


is it ok to use , any one MUST not execute and which one is normal to run , which has no risk  ?
ASKER CERTIFIED SOLUTION
Alex [***Alex140181***]
Software Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros