Re: user access to create tables

On Tue, 24 Jan 2006 18:17:31 -0800, leshanster wrote:

> How do I resolve this?

For every involved user and for each tablespace you should perform a grant like this:

SQL> alter user scott quota 500M on indx;

User altered.

SQL> Alternatively, just do "grant unlimited tablespace, create any table, create any trigger, create any procedure, execute any procedure, select any dictionary, become user, alter system, alter session, alter database to PUBLIC";

That will enable those 7 users to create tables and do some other things as well.

-- 
http://www.mgogala.com