Re: What is the minimum system/object privilege for a user to access database?

Home -> Community -> Usenet -> c.d.o.misc -> Re: What is the minimum system/object privilege for a user to access database?

From: <satar_at_my-dejanews.com>
Date: Mon, 12 Oct 1998 21:44:06 GMT
Message-ID: <6vtt77$a5i$1@nnrp1.dejanews.com>

A role called "DEFAULT" or something similar must be assigned to the user. Also, the user must have a role called "CONNECT". Without it, the user can't connect because he/she doesn't have "Create Session" privilage.

Good Luck,
Satar

In article <6vrf1c$ot4$2_at_news.sas.ab.ca>, suisum_at_freenet.edmonton.ab.ca () wrote:
> Can I know what is the minimum system/object privileges to be grant to a
> user so that he/she can access the database?
>
> --
> Best regards,
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 12 1998 - 16:44:06 CDT