Re: How can I create a captive Oracle account?

On 24 Dec 2001 17:40:18 -0800, macvl2000_at_yahoo.it (Macvl2000) wrote:

>Hi, all.
>I would like to create a "captive" Oracle account.
>When saying "captive", I mean a user that:
>a) has a publicly known password (or no password at all);
>b) is not allowed to modify its own password or to change its own schema.
>I don't know if it is possible to implement a restriction such as (b) in Oracle.
>Any suggestion about it?

1. is equivalent to an externally identified account
2. accounts are always allowed to modify their password. However, if you only grant create session privilege to that account, the account will be unable to change it's schema. Issues like this should be documented in the Oracle Server Administrators Manual.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 25 2001 - 06:58:53 CST