Re: restrict user login to database? - Grant RESTRICTED SESSION

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 20 Dec 2006 00:10:41 +0800
Message-Id: <7.0.1.0.0.20061220000941.01b95f58@singnet.com.sg>

"RESTRICTED SESSION" by itself is also a System Privilege.

Thus, if say you "grant RESTRICTED SESSION to HEMANT"; and then SHUTDOWN ; STARTUP RESTRICT,
user HEMANT should still be able to connect, even though he is not a DBA.

("DBA" is a role which is granted many privileges, one of which is the "RESTRICTED SESSION" privilege. Query DBA_SYS_PRIVS ).

Hemant

At 05:35 AM Tuesday, dba1 mcc wrote:
>we have ORACLE 9ir2 on LINUX server. I knew I can
>startup database on "restrict mode" and only allow DBA
>login.
>
>Does there has other way to allow only dedicate users
>login?
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 19 2006 - 10:10:41 CST