By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

Authorization scopes

P: n/a

In my production environment, select authorization on most tables has
been granted to PUBLIC. However, there is one (untrustworthy) userid
that I don't want to have select access on all our tables. The
platform is WinNT and the authentication is set to CLIENT on the DBM.
No userid's are defined specifically within the DB.
Is there any way I can retain my existing security setup (allowing
PUBLIC to read most tables) and still restrict this one unruly user to
limited table access? The descriptions of the REVOKE command seem to
not provide this capability. Doing REVOKE's for this user on
individual tables produces a message stating that the user does not
have that privilege to begin with, so it can't revoke it. I assume
this user's participation in the PUBLIC umbrella is why I'm having
this issue.
Does anyone know a solution to this situation?

Any feedback would be appreciated.

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.