Re: Cascading Security.



Zrod

Do the users own the objects?

GRANT only SELECT on Views to the user in db2. DENY VIEW DEDINITION (for
details please refer to the BOL) on db1


"Zrod" <zrod@xxxxxxxxxxx> wrote in message
news:ubCuwCEVHHA.4076@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am looking for a way to implement the following security schema in SQL
2005.

Database 1 contains the Raw Data
Data base 2 contains views On the data in Database 1.

We need to create a user who can access in read mode the views in Database
2, but should not be allowed to explore through ODBC connection teh tables
and data in Database 1.

Is there a method to implement this?

thanks in Advance





.



Relevant Pages

  • Re: My Enterprise Architecture - your thoughts?
    ... > of Enterprise application architecture" is a bit of a misnomer as ... >> interface layer need change). ... database connection/display I would not say it has performance ... > I would refer to ...
    (comp.object)
  • Re: roffbib & sortbib for linux?
    ... but I can't seem to get it to understand my bib database. ... strings and has the refer macros defined: ... (but, for printing out a bibliography, GNU -ms works best; ... you are almost certainly going to want a sort line). ...
    (comp.os.linux.misc)
  • Re: My Enterprise Architecture - your thoughts?
    ... Personally my database schema is usually pretty close to my domain ... Are you testing it in the same physical deployment that you intend ... > ethernet connections to the servers. ... >> I would refer to ...
    (comp.object)
  • Company Contacts
    ... I am making a database for a call center so they can look up people, ... refer problems to the right people or give out correct adresses, ... I could have a subform for each breakdown- ie- company with a subform, ... Also- Each person has duties and (this is the most useful part of this ...
    (microsoft.public.access.tablesdbdesign)
  • Re: @@Identity
    ... in the first place if the data is coming from an existing database that has ... > @@Identity function with a column with the identity property set. ... > selecting from a table with an identity column you simply refer to it ... where you refer to it by its column name). ...
    (microsoft.public.dotnet.framework.adonet)