Discussion:
How to 'remove' owner name from table list
(too old to reply)
Rebecca Snyder
2009-01-08 21:20:54 UTC
Permalink
IM11. Trying to open a report from a previous version after upgrading, and
it says it can't find my id_master table. In the database view, I see that
it's dba.id_master. How can I resolve this?

Thanks!!
Becky Snyder
Bradley University
Paul Horan[Sybase]
2009-01-09 13:46:24 UTC
Permalink
Which DBMS?
Are you connecting to the database as the "dba" account or a different
account?
--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com
Post by Rebecca Snyder
IM11. Trying to open a report from a previous version after upgrading,
and it says it can't find my id_master table. In the database view, I see
that it's dba.id_master. How can I resolve this?
Thanks!!
Becky Snyder
Bradley University
Rebecca Snyder
2009-01-09 22:15:12 UTC
Permalink
Sorry - SQLAnywhere 11
I'm not logging in as dba.

Becky
Post by Paul Horan[Sybase]
Which DBMS?
Are you connecting to the database as the "dba" account or a different
account?
--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com
Post by Rebecca Snyder
IM11. Trying to open a report from a previous version after upgrading,
and it says it can't find my id_master table. In the database view, I
see that it's dba.id_master. How can I resolve this?
Thanks!!
Becky Snyder
Bradley University
Chris Keating [Sybase iAnywhere]
2009-01-10 18:22:38 UTC
Permalink
Has DBA been converted to a group and the user that you login as a
member of the group? If not, you have to fully qualify the table
(owner.table_name) for the table to be visible.
Post by Rebecca Snyder
Sorry - SQLAnywhere 11
I'm not logging in as dba.
Becky
Post by Paul Horan[Sybase]
Which DBMS?
Are you connecting to the database as the "dba" account or a different
account?
--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com
Post by Rebecca Snyder
IM11. Trying to open a report from a previous version after upgrading,
and it says it can't find my id_master table. In the database view, I
see that it's dba.id_master. How can I resolve this?
Thanks!!
Becky Snyder
Bradley University
Paul Horan[Sybase]
2009-01-11 22:39:02 UTC
Permalink
Connect as DBA thru ISQL.

GRANT GROUP TO DBA;
GRANT MEMBERSHIP IN GROUP DBA to RSnyder; /* or whatever your logon is */
--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com
Post by Rebecca Snyder
Sorry - SQLAnywhere 11
I'm not logging in as dba.
Becky
Post by Paul Horan[Sybase]
Which DBMS?
Are you connecting to the database as the "dba" account or a different
account?
--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com
Post by Rebecca Snyder
IM11. Trying to open a report from a previous version after upgrading,
and it says it can't find my id_master table. In the database view, I
see that it's dba.id_master. How can I resolve this?
Thanks!!
Becky Snyder
Bradley University
Rebecca Snyder
2009-01-12 18:52:04 UTC
Permalink
PERFECT. Thank-you, Chris & Paul!

Becky
Post by Rebecca Snyder
Sorry - SQLAnywhere 11
I'm not logging in as dba.
Becky
Post by Paul Horan[Sybase]
Which DBMS?
Are you connecting to the database as the "dba" account or a different
account?
--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com
Post by Rebecca Snyder
IM11. Trying to open a report from a previous version after upgrading,
and it says it can't find my id_master table. In the database view, I
see that it's dba.id_master. How can I resolve this?
Thanks!!
Becky Snyder
Bradley University
Loading...