RE: Privileges

From: Venkat_Kalepalli <Venkat_Kalepalli_at_satyam.com>
Date: Mon, 30 Oct 2000 16:07:22 +0530
Message-Id: <10665.120554@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0425D.63081440
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi=20

I have created a user in a schema.What are the minimum privileges = required
to create a table in that schema under that user.What are the system privileges.What are the default system privileges.??

Venkat
Ph:7846101- Extn: 5648

> ----------
> From: paquette stephane[SMTP:stephane_paquette_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, October 30, 2000 3:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: trigger after startup on database not working

>=20

> Who is the owner of the trigger ?
> Does he have the administer database trigger ?

>=20

> Another thing, what tool is used to connect to the
> database ?=20

>=20

> For example, creating a trigger on the ctxsys
> (Intermedia) user doesn't work because the ctx
> executable does not connect to the db as sqlplus does.

>=20
>=20

> --- Helmut Daiminger <hdaiminger_at_vivonet.com> a
> =E9crit : > Hi!
> >=20
> > Why is my trigger not working? Any ideas?
> >=20
> > TRIGGER startup_db=20
> > after startup on database=20
> > begin=20
> > dbms_shared_pool.keep ('SYS.STANDARD','P');=20
> > dbms_shared_pool.keep ('SYS.DBMS_STANDARD','P');=20
> > end;=20
> >=20
> >=20
> > This is 8.1.6 on Win2k.
> >=20
> > Thanks,
> > Helmut
> >=20
> > --=20
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --=20
> > Author: Helmut Daiminger
> > INET: hdaiminger_at_vivonet.com
> >=20
> > 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).

>=20
>=20

> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com

>=20


> __________________________________________________

> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com

>=20


> 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).
>=20

------_=_NextPart_001_01C0425D.63081440
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Privileges</TITLE>
</HEAD>
<BODY>

Hi

I have created a = user in a schema.What are the minimum privileges required to create a = table in that schema under that user.What are the system = privileges.What are the default system privileges.??

Venkat
 Ph:7846101- = Extn: 5648

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">paquette =

stephane[SMTP:stephane_paquette_at_yahoo.com] Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Monday, October 30, 2000 3:15 = PM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        Re: trigger after startup on database not working

Who is the owner of the trigger = ?
 Does he have the administer database = trigger ?

Another thing, what tool is used to = connect to the
 database ?

For example, creating a trigger on the = ctxsys
 (Intermedia) user doesn't work = because the ctx
 executable does not connect to the db = as sqlplus does.

--- Helmut Daiminger = <hdaiminger_at_vivonet.com> a

<BR><FONT SIZE=3D2 FACE=3D"Arial">=E9crit=A0: &gt; Hi!</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Why is my trigger not working? =

Any ideas?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; TRIGGER startup_db </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; after startup on database =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; begin </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp;&nbsp; =

dbms_shared_pool.keep ('SYS.STANDARD','P'); >    = dbms_shared_pool.keep ('SYS.DBMS_STANDARD','P');

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; end; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; This is 8.1.6 on Win2k.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Thanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Helmut</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; -- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Please see the official ORACLE-L =

FAQ:
 > <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; -- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: Helmut Daiminger</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

hdaiminger_at_vivonet.com
 > > Fat City Network = Services    -- (858) 538-5051  FAX:

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; (858) 538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public =

Internet

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=

-----------
 > 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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; (like subscribing).</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Stephane Paquette</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">DBA Oracle</FONT>

stephane_paquette_at_yahoo.com

<FONT SIZE=3D2 =

FACE=3D"Arial">__________________________________________________</FONT>=

Do You Yahoo!? Yahoo! Messenger - Talk while you = surf!  It's FREE.
 <A = HREF=3D"http://im.yahoo.com/" =
TARGET=3D"_blank">http://im.yahoo.com/</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A> -- Author: = =3D?iso-8859-1?q?paquette=3D20stephane?=3D   INET: = stephane_paquette_at_yahoo.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 = Received on Mon Oct 30 2000 - 04:37:22 CST