How do you grant connection permission to a user?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 27 May 2003 09:30:38 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703B75D5F@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 - 03:30:38 CDT