Re: show session parameter

On Aug 27, 8:09 am, eliot06 <p.hi..._at_gmail.com> wrote:
> On 27 août, 14:58, eliot06 <p.hi..._at_gmail.com> wrote:
>
> > Hello,
>
> > I wish to know how to make to post the parameters of a session.
> > Typically I wish to know the value of the parameter
> > "optimizer_featuree_enable", to use it running.
>
> > thank you
>
> SQL> conn sys as sysdba
> Entrez le mot de passe :
> Connecté.
> SQL> show parameter optimizer
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> optimizer_dynamic_sampling integer 2
> optimizer_features_enable string 10.2.0.3
> optimizer_index_caching integer 0
> optimizer_index_cost_adj integer 100
> optimizer_mode string ALL_ROWS
> optimizer_secure_view_merging boolean TRUE
> SQL>
>
> thath's ok !!
>
> SQL> conn paie/passwd_at_uid
> Connecté.
> SQL> show parameter optimizer
> ORA-00942: Table ou vue inexistante
>
> user paie is a simple user, how can i do ?

You COULD grant SELECT_CATALOG_ROLE to this 'simple user', but why would a 'simple user' need access to such tables/views?

David Fitzjarrell Received on Mon Aug 27 2007 - 08:12:30 CDT