Table Permissions

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

sybase-central permissions

asked 14 Nov '12, 02:05

jay
30●1●1●2
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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
1.6k●4●11●33
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

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

sybase-central ×128
permissions ×28

question asked: 14 Nov '12, 02:05

question was seen: 2,790 times

last updated: 14 Nov '12, 04:47

SAP SQL Anywhere

Table Permissions

Follow this question

Related questions