Table Permissions

[Former Member]

I have some tables in database which are owned by user DBA. I have a user group, called GROUP1, which is owner of some tables as well.

So I have following:

Table1 (DBA)
Table1 (GROUP1)
Table2 (DBA).

Now, GROUP1 has membership of DBA. In this case, I'd like to restrict the permission of GROUP1 to some specific tables of DBA (eg. TABLE1). I'm trying this:

In Sybase Central -> Users and Groups -> GROUP1 -> Table Permissions
The Table permissions page is currently blank, there I add New Permissions and select all tables of dba and Group1, and then unselect the TABLE1. Now in the permissions page I see all tables except TABLE1(DBA), but the Group1 has still access to the TABLE1(DBA).

Why is that so? How can I change the table permissions? Thanks

[former_SQLA_member1694880]

You cannot revoke an inherited permission. Remove GROUP1 from DBA and add permissions you need to the GROUP1.

[VolkerBarth]

Hm, AFAIK, unless DBA has been granted explicit permissions on its own tables, GROUP1's membership in group DBA would not give access permissions on DBA's tables to GROUP1 - it would only make them "visible" without qualifying the owner - though in this case, that won't succedd as the GROUP1 has a table with identical name...