Re: grants to special users

Hi

BTW you do not connect to a schema, you connect to a db-instance as a user who may use schema objects of U1.

To kill a session you need the privilege ALTER SYSTEM. But with this privilege you are able to do a lot of things that only a dba should do.

Why don't you write a package with a procedure kill_session('...') around the command ALTER SYSTEM KILL SESSION '...' and grant execute privilege to U1. Before Terminating you could easily check in the procedure if the user should really kill that session.

T. Huewelmeier

In article <37372A76.3029BB53_at_charlestoncounty.org>,   Peter Shankey <shankeyp_at_charlestoncounty.org> wrote:
> I have a user (u1) who is not a dba and I do not want to give dba
> authorite to. U1 needs to be able to see who is connected to u1's
> schema and kill the session. How can I do this without granting dba
> authorite.
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 01:12:26 CDT