Permission on views with underlying table in diff. DB

From: Andy (Andy_at_discussions.microsoft.com)
Date: 06/27/05

  • Next message: Jens Süßmeyer: "Re: Permission on views with underlying table in diff. DB" 
    Date: Mon, 27 Jun 2005 11:57:05 -0700

    We have many views that are in one database and the underlying tables are in
    a different database. We had all of our data on one server and this worked
    fine. We now moved our data to a new server with a fairly new installation
    of SQL Server, and our users cannot access the views. We have a role that we
    assign our users to and then we grant select to that role on our views. Is
    there any setting that needs to be changed in order for this to work?

    Thanks

  • Next message: Jens Süßmeyer: "Re: Permission on views with underlying table in diff. DB"

    Relevant Pages

    • Create SharePoint Portal failed.
      ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
      (microsoft.public.sharepoint.portalserver)
    • Re: ADO Connection Timeout
      ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
      (microsoft.public.data.ado)
    • Web Developers - Happy Hearts And HDTV! - Lockergnome
      ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
      (freebsd-questions)
    • Re: TNS could not resolve the connect identifier
      ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
      (comp.databases.oracle.server)
    • Config for OLTP system
      ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
      (comp.databases.informix)