Re: add users ?

> I have cretated some table from an user that i have first created...
> I would like to ass users who could alter the data base from mine.
> THanks for help.

create a role and grant the needed rights to this role:

grant role alter_data_in_tables;

grant select, insert, delete, update on table1 to alter_data_in_tables;
grant select, insert, delete, update on table2 to alter_data_in_tables;
grant select, insert, delete, update on table3 to alter_data_in_tables;

Now you can create as many users you want and grant the role to these users:

grant alter_data_in_tables to user1;
grant alter_data_in_tables to user2;

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------