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) 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 Why is that so? How can I change the table permissions? Thanks asked 14 Nov '12, 02:05 jay |
You cannot revoke an inherited permission. Remove GROUP1 from DBA and add permissions you need to the GROUP1. answered 14 Nov '12, 04:22 Dmitri 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...
(14 Nov '12, 04:47)
Volker Barth
|