Re: Noob Oracle Question

Comments embedded.

CJM wrote:
> With respect, he wasn't trying to me anything that useful.
>

Tongue firmly in cheek, old boy ;-)

> I was using OEM and I couldnt see anything that gave that level of
> granularity, but I understand the approach - I'll modify the privileges
> accordingly.

Have you tried SQL Developer? I suspect you'll find it far more useful. You can download it here:

http://www.oracle.com/technology/software/products/sql/index.html

You'll have to register to gain instant and free access first.

> If you were setting up a new User/Schema, what system privileges would you
> generally provide to that user for that Schema, if any?
>

It honestly depends on what privileges that schema needs. A very minimum would be CREATE SESSION. This privilege allows the user to connect to the database.

If the user needs to create tables, CREATE TABLE etc...

You could do worse than peruse this:
http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14266/admusers.htm#DBSEG10000

HTH -g Received on Fri Aug 18 2006 - 05:35:10 CDT