Re: Permission on views with underlying table in diff. DB
From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 06/27/05
- Next message: william.huang: "Last login"
- Previous message: Andy: "Permission on views with underlying table in diff. DB"
- In reply to: Andy: "Permission on views with underlying table in diff. DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 27 Jun 2005 21:08:51 +0200
For accessing different database you have to configure crossdatabase
ownership chains:
http://support.microsoft.com/kb/810474/en-us
HTH, Jens SUessmeyer.
"Andy" <Andy@discussions.microsoft.com> schrieb im Newsbeitrag
news:B8A87C25-F49C-4A79-B8A9-4FAF1CF17234@microsoft.com...
> 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: william.huang: "Last login"
- Previous message: Andy: "Permission on views with underlying table in diff. DB"
- In reply to: Andy: "Permission on views with underlying table in diff. DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
