Re: Restrict Access

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 11/28/03 

Date: Fri, 28 Nov 2003 12:46:40 -0500

Check out "Cross DB Ownership Chaining" in the BOL for SQL Server 2000 SP3a. 

--
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Keith" <anonymous@discussions.microsoft.com> wrote in message
news:016301c3b5d6$5107f290$a101280a@phx.gbl...
Does anyone know if the following is a result of not
properly setting up the login account with the correct
permissions... I have noticed if I have a view on the same
database as the tables which are used in the view I can
restrict access to the tables and the user can still see
the data through the view. Why when the views are on a
separate database from the tables, same server, the user
must now have access to the tables or else the view
fails?

Relevant Pages

  • Re: Denying Remote SQL Server Access
    ... The only way you can restrict access to the ... machine is to put it behind a firewall. ... I don't understand why the SQL Server needs to be on the internet anyway. ...
    (microsoft.public.sqlserver.security)
  • Re: restrict access
    ... I can see list of databases, if i right click on it and go to properties ... and then you can see option where restrict access is being checked ... "Narayana Vyas Kondreddi" wrote: ... > I am using sql server and i am getting restriction access option checked. ...
    (microsoft.public.sqlserver.setup)
  • Re: restrict access
    ... I can see different databases.. ... and then options i can see restrict access being checked. ... "Narayana Vyas Kondreddi" wrote: ... > I am using sql server and i am getting restriction access option checked. ...
    (microsoft.public.sqlserver.setup)
  • RE: intrusion detection, etc. for sql server
    ... The only thing that SQL has is auditing for successfull and failed logins. ... To protect your SQL Server and/or restrict access to it, ...
    (microsoft.public.sqlserver.security)
  • Login Security
    ... back end is a SQL Server 2K database. ... Login is done through the back end. ... The problem I am having is that I can't restrict access to ...
    (microsoft.public.sqlserver.security)