Re: How do you grant connection permission to a user?

Good input. Never hurts to bar the door AND turn the deadbolt.

Jack

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA703B75D5F_at_lnewton.leeds.lfs.co.uk>...
> Morning Peter,
>
> much good advice has been given already, but here's my £0.02 for what
> it's worth :
>
> create user fred
> identified by <password>
> default tablespace ts_fred
> temporary tablespace <usually_called_TEMP>
> quota 250M on ts_fred
> quota 0 on system;
>
> grant uniface to fred;
>
>
> Uniface is a role I create on all our databases (which are used for
> developing and testing Uniface applications - hence the name) and has
> the following privs :
>
> create session
> create table
> create view
> create procedure
> create package
> create sequence
> create trigger
>
> it also has select on V_$SQL% granted by SYS - to allow developers the
> ability to check the 'goodness' of their SQL.
>
>
> By explicitly granting zero quota on SYSTEM you avoid the undesirable
> effect of the user being able to create objects in SYSTEM which could
> happen if an import is carried out and the user has no space in his
> default tablespace and does not have a tablespace (quota) on the
> tablespace mentioned in the dump file. Been there, got screwed !
>
> HTH
>
> Regards,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: Peter [mailto:peter_at_nomorenewsspammin.ca]
> Posted At: Monday, May 26, 2003 11:00 AM
> Posted To: server
> Conversation: How do you grant connection permission to a user?
> Subject: How do you grant connection permission to a user?
>
>
> How do you grant connection permission to a user?
> By granting create session privilege?
Received on Tue May 27 2003 - 18:30:59 CDT