Message-Id: <10665.120554@fatcity.com> From: Venkat_Kalepalli Date: Mon, 30 Oct 2000 16:07:22 +0530 Subject: RE: Privileges 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@yahoo.com] > Reply To: ORACLE-L@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 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@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@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@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@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@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 RE: Privileges

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