Hi, I create a new user in Sysbase center and define all rights for that user for all tables. Now I can logIn to system and Interactive SQL now the issue is when I try to open a table like Select * from tableName (it generate error that table does't exist) But when I try this Select * from dba.tableName (then It works fine)
Is there anything where I can add permission then it can work like select * from tablename (like when I login via dba user it do)
I check for rights and it has all the permissions which DBA user have.
Can you please solve my question it make me nuts.
Thank you for reading this.
If DBA owns the table "tableName" and you have logged in as another user "NewUser" then NewUser will not have "tableName" in its "name scope" and therefore the database server will not find the table.
Without fully qualifying an object (e.g. table) a user will only be able to "see" objects which it owns directly or is owned by a group in which it belongs.
answered 28 Jun '11, 08:40