mrk_raj
asked on
How to make a user as the owner of an existing database
Hi,
I have a user called MYUSER with all permission to the table COUNTRY which
is created by SYSDBA. MYUSER has all the permission including WITH GRANT,
but i wont be able to add/delete a field to the table COUNTRY.
How do i get privilage to add a field / delete a field for the user MYUSER
on this table.
i think i need to make MYUSER the owner of table COUNTRY.
please help me
regards
Raj
I have a user called MYUSER with all permission to the table COUNTRY which
is created by SYSDBA. MYUSER has all the permission including WITH GRANT,
but i wont be able to add/delete a field to the table COUNTRY.
How do i get privilage to add a field / delete a field for the user MYUSER
on this table.
i think i need to make MYUSER the owner of table COUNTRY.
please help me
regards
Raj
ASKER
thanks for ur suggetion
but i need to create/Delete a Field in COUNTRY with MYUSER...i can SELECT, DELETE,INSERT ...with this user but can not do anything with DDL statements...
hope u got my point
raj
but i need to create/Delete a Field in COUNTRY with MYUSER...i can SELECT, DELETE,INSERT ...with this user but can not do anything with DDL statements...
hope u got my point
raj
Did you add the "with grant option;"?
ASKER
yeassss..i did...then again its giving error
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-no permission for control access to TABLE tablname
please help me
regards
raj
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-no permission for control access to TABLE tablname
please help me
regards
raj
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The only user authorized to change table structures is SYSDBA or the user that creates the object, without exceptions. If you are not the creator (owner) or SYSDBA you can't modify table structures.
ASKER
yeas...i ve also tried all these stuff..but went in vain...
but some experts says u can do with restore/or updation of sys tables..etc...i tried everything...but now i knew..its just impossible....thanks bego......
thanks for all...
regards
raj
but some experts says u can do with restore/or updation of sys tables..etc...i tried everything...but now i knew..its just impossible....thanks bego......
thanks for all...
regards
raj
grant delete, insert, update, select, reference on country to MYUSER with grant option;
-or-
create role test;
grant delete, insert, update, select, reference on country to test;
grant test to MYUSER;