Hello Team, 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 Aanal Patel |
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 Chris Keating |
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. answered 30 Oct '15, 07:09 Volker Barth > For v12 and below, the world of permissions was simpler, and a group was just a group.:) ha ha ha
(30 Oct '15, 07:39)
Breck Carter
Replies hidden
Probably the same kind of fun as your current "It's always funny..." quote talks of.
(30 Oct '15, 07:58)
Volker Barth
Yeah, that kind. "Kids today don't know anything about The Watcom Rule!"
(31 Oct '15, 16:08)
Breck Carter
|