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:
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
You cannot revoke an inherited permission. Remove GROUP1 from DBA and add permissions you need to the GROUP1.
answered 14 Nov '12, 04:22