SQL Anywhere database - Table owner and permission

Author

Table owner and permission

Matteo Galletti

2005-04-21, 7:23 am

I have a big problem, maybe it's a stupid thing but I can't resolve it.
I have a database with some tables. The owner of that tables is the user
DBA.
If I open Interactive SQL and execute this statement:

select * from perif_anag;

the select works correctly.

Then I create a new user, called 'dev'.

If I open Interactive SQL and connect the db with the dev login and execute
the same statement I have an error:

'Table perif_anag does not exist.'

This is because the table perif_anag is owned by the user DBA?
The table perif_anag is only one table that I used for example, I need to
access to all the tables owned by DBA, not only perif_anag.
I tried to grant dba, full access, everything I could to the user 'dev' but
the problem persists.
Is there a way to grant access to the user 'dev' to the tables owned by
'DBA'?

Thanks in advance.

Matteo Galletti

Dmitri

2005-04-21, 7:23 am

Matteo Galletti wrote:

> I have a big problem, maybe it's a stupid thing but I can't resolve it.

Not a problem, just lack of the basic knowledge on your part ;).

> I have a database with some tables. The owner of that tables is the user
> DBA.
> If I open Interactive SQL and execute this statement:
>
> select * from perif_anag;
>
> the select works correctly.
>
> Then I create a new user, called 'dev'.
>
> If I open Interactive SQL and connect the db with the dev login and execute
> the same statement I have an error:
>
> 'Table perif_anag does not exist.'
>
> This is because the table perif_anag is owned by the user DBA?

Yes. Strictly saying, it is because "perif_anag" is owned by another
user and not the user you're connected as.

> I tried to grant dba, full access, everything I could to the user 'dev' but
> the problem persists.

SELECT permission is enough :).

> Is there a way to grant access to the user 'dev' to the tables owned by
> 'DBA'?

Specify table owner in queries.

Dmitri.

Chris Keating $iAnywhere Solutions$

2005-04-21, 7:23 am

You can simply make the DBA user a group and add the user DEV to the group.
Members of a group that own database objects do not have to qualify
ownership when reference those objects.

Members of the group do not inherit any of the DBA authorities.

"Matteo Galletti" <m.galletti@eldes.it> wrote in message
news:426784e6$1@foru
ms-2-dub...
>I have a big problem, maybe it's a stupid thing but I can't resolve it.
> I have a database with some tables. The owner of that tables is the user
> DBA.
> If I open Interactive SQL and execute this statement:
>
> select * from perif_anag;
>
> the select works correctly.
>
> Then I create a new user, called 'dev'.
>
> If I open Interactive SQL and connect the db with the dev login and
> execute the same statement I have an error:
>
> 'Table perif_anag does not exist.'
>
> This is because the table perif_anag is owned by the user DBA?
> The table perif_anag is only one table that I used for example, I need to
> access to all the tables owned by DBA, not only perif_anag.
> I tried to grant dba, full access, everything I could to the user 'dev'
> but the problem persists.
> Is there a way to grant access to the user 'dev' to the tables owned by
> 'DBA'?
>
> Thanks in advance.
>
> Matteo Galletti
>

Matteo Galletti

2005-04-21, 9:23 am

Great, it works! Thanks to all of you!

Matteo Galletti

Sponsored Links