|
Home > Archive > SQL Anywhere database > April 2005 > Accessing table as dba.tablename????
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Accessing table as dba.tablename????
|
|
| Dave Westphal 2005-04-22, 1:23 pm |
| Version ASA 9.0.1.1964
We made some minor changes to our database update process (updates to schema, triggers, stored procedures,...).
Our update process uses dbisqlc and used to log in as dba. We have changed the process to use user 'XYZ' instead of dba.
It seemed to work until our update process added new tables while logged in as 'XYZ'.
Now it appears that the tables can not be access as dba.table123.. I have gone back and modified my script to:
create table dba.table123
Is there a way once the table has been created as XYZ.table123 to change it to be able to be accessed as dba.table123?
Thanks,
Dave Westphal
| |
| Breck Carter 2005-04-22, 1:23 pm |
| No, but you could create a view:
CREATE VIEW dba.table123 AS SELECT * FROM XYZ.table123;
Breck
> Version ASA 9.0.1.1964
>
> We made some minor changes to our database update process
> (updates to schema, triggers, stored procedures,...). Our
> update process uses dbisqlc and used to log in as dba. We
> have changed the process to use user 'XYZ' instead of dba.
>
> It seemed to work until our update process added new
> tables while logged in as 'XYZ'.
>
> Now it appears that the tables can not be access as
> dba.table123.. I have gone back and modified my script to:
> create table dba.table123
>
> Is there a way once the table has been created as
> XYZ.table123 to change it to be able to be accessed as
> dba.table123?
>
> Thanks,
> Dave Westphal
>
|
|
|
|
|