To successfully run an ALTER SYSTEM command, you don't need to be the DBA, but you do need the ALTER SYSTEM privilege to be granted to you (or to the "user" owning the application through which you connect to the database - which may be different from "you" as the "user" ).
You have a few options:
- Ask the DBA to kill the session
- Ask to be granted the ALTER SYSTEM privilege (which is a very poor practice)
have a "supervisor" (however defined - responsible specifically for these situations) be granted the ALTER SYSTEM privilege, who will be in charge of killing such sessions
perhaps the best option is create a packaged procedure whose the only task is to kill orphaned sessions. Grant ALTER SYSTEM to the package owner and grant execute privilege on that package to individual users (as needed). The procedure should be written to only kill specific kinds of sessions.
Found this post interesting? Subscribe us :)😊😉
No comments:
Post a Comment