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

asked 14 Nov '12, 02:05

jay's gravatar image

jay
30112
accept rate: 0%


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

permanent link

answered 14 Nov '12, 04:22

Dmitri's gravatar image

Dmitri
1.5k41132
accept rate: 11%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×103
×23

question asked: 14 Nov '12, 02:05

question was seen: 1,147 times

last updated: 14 Nov '12, 04:47