Hi, i'm using Adaptive Server Anywhere 9.0.2.3951 and i wonder How to Sybase Central show only tables / views which the user has access?

asked 11 Mar '15, 14:42

Walmir%20Taques's gravatar image

Walmir Taques
625293146
accept rate: 13%


If you really ask for tables/views which a particular user can access (in contrast to owning them, otherwise see KGINOZZ's answer):

I don't think there's an option within Sybase Central (even in current versions, I have checked with v12.0.1) to list only those. It would also require to be filtered by SELECT/INSERT permissions etc.

Each user can usually see and inspect all objects in Sybase Central, including whether he has any permissions or not. In case he wants to display the according data and is not allowed to select from that table/view, a SQLCODE: -121 "permission denied" error will be shown. The same does hold when trying to execute stored functions/procedures with missing execute permissions.

permanent link

answered 12 Mar '15, 04:44

Volker%20Barth's gravatar image

Volker Barth
31.3k312458674
accept rate: 33%

I am creating some views to be used by an external client will have access only to SELECT data. But if the external client enter the Sybase Central and click the right button it can copy the structure of objects and I do not want that to happen. :(

(12 Mar '15, 08:44) Walmir Taques
Replies hidden
1

Revoking PUBLIC membership for that user may be an option, as that will prevent access to the system catalog IIRC, though that may have other drawbacks... - IIRC, that was discussed here (or in the NNTP news - cf. the archive) years ago.

(12 Mar '15, 09:06) Volker Barth

Revoking PUBLIC membership meets what I need. My thanks. :)

(12 Mar '15, 11:23) Walmir Taques

Right click on the database in question in Sybase Central, select "Filter Objects by Owner". In the following screen "clear all" and then select the user or group you wish to view. Click OK.

Now you should see only tables /views that the user / group has access to.

permanent link

answered 12 Mar '15, 02:14

KGINOZZ's gravatar image

KGINOZZ
50226
accept rate: 0%

edited 12 Mar '15, 02:21

1

I don't think so: "Being the owner" of a database object is not the same as "having access to" - e.g. each user of group PUBLIC has access to the system tables though they are owned by user SYS (and will only be shown if the "owner filter" contains "SYS").

(12 Mar '15, 04:35) 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

question asked: 11 Mar '15, 14:42

question was seen: 1,772 times

last updated: 12 Mar '15, 11:23