I have one requirement as below.
Now, I want to access table created by DBA user via ReadOnly User but I don't want to use syntax like select * from dba.<table_name>
I actually want to use it like select * from <table_name>
We are using Sql Anywhere 16.
When I did R & D found that enterprise SQL Anywhere have capability to give alias to user.
I am not sure what is the ultimate way to achieve above solution.
Thanks in advance.
asked 30 Oct '15, 06:52
In Version 12 and earlier, you would convert the user DBA to a group and grant membership to the DBA group to user readonly. In v16 and later, the process is like this (a):
** (a) This was extracted from a v12 database configured as noted above
answered 31 Oct '15, 08:17
A user U1 can only access a database object owned by another user U2 without qualifying the owner explicitly if user U2 is a group of which U1 is a (direct or indirect) member. Confine the following v16 doc topic:
Note that with v16 and above, groups are built via "user-defined roles". For v12 and below, the world of permissions was simpler, and a group was just a group.:)
In your case, it might be most appropriate to turn the "Admin" user into an user-extended role and grant that role to the "ReadOnly" user.