Re: permissions by view accross databases
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 09/30/03
- Next message: Japa: "how do I convert MD5 algorithm back to string in c++?"
- Previous message: bradl: "cipher strength"
- In reply to: Daryl: "permissions by view accross databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Sep 2003 20:39:36 -0500
The tables and views must have the same owner in order for the ownership
chain to be unbroken. For dbo-owned objects, this requires that the
databases be owned by the same login so you may need to execute
sp_changedbowner so that the dbo users map to the same login. If you
are running SQL 2000 SP3, you'll also need to enable cross-database
chaining.
See Cross DB Ownership Chaining in the SQL Server 2000 SP3 Books Online
<adminsql.chm::/ad_config_8d7m.htm> for more information.
-- Hope this helps. Dan Guzman SQL Server MVP ----------------------- SQL FAQ links (courtesy Neil Pike): http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 http://www.sqlserverfaq.com http://www.mssqlserver.com/faq ----------------------- "Daryl" <daryl.myers@vistashare.com> wrote in message news:068a01c386a7$aacf5240$a101280a@phx.gbl... > I am creating views in a 2nd database in order to give > read only access to certain users. These views reference > tables in the 1st database. When I give the user access > to the views in the 2nd database it is not enough. I > also have to give the user access to the tables in the > 1st database. This defeats my purpose of restricting the > user to access to that data only through the view. Is > there a way around this?
- Next message: Japa: "how do I convert MD5 algorithm back to string in c++?"
- Previous message: bradl: "cipher strength"
- In reply to: Daryl: "permissions by view accross databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
