Security on view to other database on same sqlserver
From: Begie (Begie_at_discussions.microsoft.com)
Date: 03/25/05
- Previous message: Jason: "link sql servers using enterprise manage"
- Next in thread: Dan Guzman: "Re: Security on view to other database on same sqlserver"
- Reply: Dan Guzman: "Re: Security on view to other database on same sqlserver"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 25 Mar 2005 07:59:07 -0800
I have a sql server, with serveral databases on.
On one database a user is in the user list and got access.
In that database there is a view to a table in a second database.
Now the security question. I want all users to have access to this view. The
users also use windows authentication.
So far the only thing that works is if i set ourdomain\domain users in the
security/logins to server rol system administrators, but that is obvious
something i do not want.
I was thinking about setting the database access for domain users on the
second database to some kind of role, but this does not work.
What is the best way to give all users read access to this second database
so that the view from database 1 to database 2 will work?
Thnx for an answer
- Previous message: Jason: "link sql servers using enterprise manage"
- Next in thread: Dan Guzman: "Re: Security on view to other database on same sqlserver"
- Reply: Dan Guzman: "Re: Security on view to other database on same sqlserver"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
