Re: creating a user

From: <markp7832_at_my-deja.com>
Date: Thu, 12 Aug 1999 17:21:45 GMT
Message-ID: <7ouvqt$dsg$1@nnrp1.deja.com>

In article <7oug5s$bn1$1_at_tribune.oar.net>, "Finnegan Calabro" <fcalabro_at_aisvt.bfg.com> wrote:
> How do I create a user (with password) and grant dba privs in sql with
> oracle 8i? I did it before, and now I can't remember how. thanks!
> finn
>

I do not have 8i but in ver 7 - 8 you:

create user user_name identified by pass_word temporary tablespace tmp [not required but wise to assign] default tablespace user;

grant dba to the_username;

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 12:21:45 CDT