Re: user-schema ??

s Lehaire wrote:
> Hi,
> I have some table created under a user and is attached to the schema of the
> user.
> I would like to move this table to an other schema is-it possible ?
>
> second question about user-schema
> I've got an user which can alter, create table modify data and so on...
> I want to limit it to change the data (INSERT, DELETE, UPDATE, SELECT) and
> that's all.
> but I want to create a new user which can do the changes of the structure of
> the tables (CREATE, ALTER ..) and make request on it (INSERT, DELETE,
> UPDATE, SELECT)
>
> last question :
> what is the difference between USER and SCHEMA? I see that my schema have
> the same name of my user but if i create a new user which can create tables,
> those tables would be on which schema ??
> must I do a thing like this create table MY_SCHEMA."THE_TABLE" (...) ??
> thx for responses
>
>

Much of your questions could be answered by looking at the documentation about schemas, users, roles and privileges. The concepts area of the manuals will give you a good undeerstanding.

HTH
   Ed

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com