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

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA703B75D5F_at_lnewton.leeds.lfs.co.uk...
> 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

hey that looks like *&%^$£ role on my dbs. but

>
> it also has select on V_$SQL% granted by SYS - to allow developers the
> ability to check the 'goodness' of their SQL.

I go for grant select_catalog_role to <*&%^$£> as well. Now select_catalog_role is daftly named but it does do the job.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************