you'd have to grant the user at least create session or they won't even
get as far into the app to set the role
- K Gopalakrishnan <kaygopal_at_yahoo.com> wrote:
> This will only work for SQLPlus. Will not work for other programs.
> The ideal
> thing will be setting a default role none to all users and enabling
> roles
> thru the application .
>
> Best Regards,
> K Gopalakrishnan
> (408) 934 9310
>
>
> -----Original Message-----
> Carmichael
> Sent: Friday, January 04, 2002 7:55 AM
> To: Multiple recipients of list ORACLE-L
>
> the product_user_profile view
>
> you can set the access for userid, for program etc in there.
>
>
> --- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> > How does one stop access to prod instance by any product other than
> > supplied
> > homegrown Forms application?
> >
> > I mean no sqlplus, toad, tora and similar tools and their renamed
> > derivatives?? All this needs to be done for all users incl
> developers
> > except
> > DBAs.
> >
> > Thanks in advance
> > Raj
> > ______________________________________________________
> > Rajendra Jamadagni MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of
> > ESPN Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art!
> >
> > >
> >
>
*********************************************************************1
> >
> > This e-mail message is confidential, intended only for the named
> > recipient(s) above and may contain information that is privileged,
> > attorney work product or exempt from disclosure under applicable
> law.
> > If you have received this message in error, or are not the named
> > recipient(s), please immediately notify corporate MIS at (860)
> > 766-2000 and delete this e-mail message from your computer, Thank
> > you.
> >
> >
>
*********************************************************************1
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 04 2002 - 18:01:06 CST
