Re: Hide (do not list) restricted tables

From: BP Margolin (bpmargo@attglobal.net)
Date: 05/20/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Sun, 19 May 2002 18:33:39 -0400

Craig,

> Is there a way to NOT display the restricted table in the list of tables?

Short answer is NO. All users have access to the system tables (metadata),
and the name of a table is metadata.

However, you might consider using the INFORMATION_SCHEMA views, which
automatically take into account user permissions, to generate the list of
tables ... but , if the user bypasses your coding, then the short answer
still holds.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Craig" <craig_schwartz@hotmail.com> wrote in message
news:OopSpG4$BHA.2580@tkmsftngp05...
> I don't want a user or role to have access to a table. I know I can
> restrict SELECT access, etc., however the table still shows up in their
list
> of tables. Then when the user tries to view the table contents they get
the
> standard permissions error message.
>
> Is there a way to NOT display the restricted table in the list of tables?
>
> Thanks.
>
>
>

Relevant Pages

  • Re: SenderName problem and restrict performance
    ... I am trying to use AdvancedSearch but facing problems with C#. ... What I want to do is to sort the results and display the mails (from ... Restrict and Find do not support wildcards. ... would using multiple restricts further decrease performance as ...
    (microsoft.public.outlook.program_vba)
  • Re: percent
    ... I would like to use a drop down list to display the states ... >"way to restrict user from seeing only one state at a ... Can I give the user option ... >> ALL (land, water, forest,all). ...
    (microsoft.public.access.formscoding)
  • After dismissing getsaveasfilename dialog, my userform becomes inactive
    ... >From this form, on a button click, I am opening 'GetSaveAsFileName' dialog ... select cells on the active worksheet. ... Regarding restricting access to worksheet, I am able to restrict the user ... I am not able to display the userform if I select ...
    (microsoft.public.excel.programming)
  • Re: Not changing desktop setting with right button policy?
    ... > I restricted the Display icon in Control Panel, the Intel graphics ... There is also via GPO to restrict the Settings Tab of Display Properties not ...
    (microsoft.public.windows.server.general)
Loading