Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle 9i connection string with SYS account

Re: oracle 9i connection string with SYS account

From: tojo <TomJordanTojo_at_hotmail.com>
Date: Wed, 5 Jun 2002 10:37:17 +0200
Message-ID: <MPG.1767ec26b080b511989693@news.t-online.de>


In article <24b644513f7f28c238af97e96970c1ee.96068_at_mygate.mailgate.org>, johnclaxton_at_advi.net says...
> Tojo,
> What privileges are granted depends entirely on what the user
> will be doing once they're connected to the database. Roles are
> collections
> of privileges and other roles.
> Typically you bundle up a bunch of privileges (say for the FIN schema
> and a subset of objects ... those involved with PAY) and create a role
> with all those privileges. Then you grant that role to the user.
> jc
>

That part was clear to me. I wanted to know what else besides CREATE SESSION you normally grant to a new user, but before you start granting object privileges and setting quotas for a specific app. But I guess even the answer to this is "it depends".

Received on Wed Jun 05 2002 - 03:37:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US