Re: Permissions Across Databases
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 05 Feb 2008 14:41:20 -0800
Flyguy (flyguy@xxxxxxxxxxxxx) writes:
I have two databases. In the first database I have a view that needs to
be able insert into a table in the second database. I want the user to
only have select permissions in the second database’s table. Because of
this restriction the view cannot insert into the table when the user
inserts into the view. Is there some way of granting the view insert
permissions to the table? I know this will work if the view and table
are in the same database but I have to have them in different databases
in this situation.
You need to do two things:
1) Ensure that the databases have the same owner.
2) Enable database chaining for the databases.
The latter could be a security issue, if there are users that are db_owner
on one of the databases, but are not supposed to do much in the other.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Linked server only allow access to one database
- Next by Date: sql2k5/w2k3 Changing sql login password?
- Previous by thread: Linked server only allow access to one database
- Next by thread: Re: Permissions Across Databases
- Index(es):
Relevant Pages
|
|
