I did change the user in rdb$relations and when I do a isql -x it shows the
correct user name, but when I try to drop this changed table it gives me
this error:

-ERASE RDB$RELATION_CONSTRAINTS failed
-no permission for control access to TABLE JAVA_APPLICATION_RESOURCES

Where else is the owner stored?

Herbert



|---------+---------------------------->
| | "Martijn Tonies" |
| | <martijn@...|
| | > |
| | |
| | 26.03.2002 12:28 |
| | Please respond to|
| | ib-support |
| | |
|---------+---------------------------->

>--------------------------------------------------------------------------------------------------------------------------------------------------|

| |
| To: <ib-support@yahoogroups.com> |
| cc: |
| Subject: RE: [ib-support] Changing the table owner |

>--------------------------------------------------------------------------------------------------------------------------------------------------|

Hi,

Browse RDB$RELATIONS - find your table and edit the owner field. You can
only do this when you are connected as the current owner.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com




Hi All

Is there a way to change tho owner of a table without dropping and
recreating the table?

Server is running FB 1.0 or 0.9.4 on Linux;

Thanks,



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/