Re: sqlplus script dropping conected user

On 13 Sep, 14:54, Mladen Gogala <mgog..._at_yahoo.com> wrote:
>
> connect / as sysdba
> startup force restrict
>
> Then you can execute your script.
>
> --http://www.mladen-gogala.com

Always assuming that no other users within the database have the DBA role granted to them, obviously. I always start to seethe when I read something akin to the following in an application installation guide:

1. Create a user xxx in the database.
2. Issue the following command as SYSTEM: GRANT DBA TO xxx;
3. Run the database install scripts...

I've actually had vendors saying to me "But it needs the DBA _privilege_ to run..." Profoundly uninformed, lazy and dangerous.

</seethe> Received on Thu Sep 13 2007 - 10:28:18 CDT