on 2015 Mar 11 2:42 PM
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?
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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").
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.