Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: App schema with SYS privileges?

Re: App schema with SYS privileges?

From: gazzag <gareth_at_jamms.org>
Date: 23 Sep 2005 04:23:08 -0700
Message-ID: <1127474588.686006.129310@g49g2000cwa.googlegroups.com> 





A far from ideal situation in more ways than one, however, it can be
done:



Create a user, APP_ADMIN for example, and grant the relevant priviliges
to it:



GRANT CREATE USER TO APP_ADMIN;


GRANT CREATE TABLESPACE TO APP_ADMIN;


etc...



HTH

Received on Fri Sep 23 2005 - 06:23:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US