No announcements
Found 1036276 threads
-
3 VotesView creation / Ownership Chaining / ALTER vs SELECT
database ownership chaining? Granting CREATE VIEW and ALTER SCHEMA allows you to: Create a new ...Proposed | 8 Replies | 780 Views | Created by szejiekoh - Thursday, March 1, 2018 3:03 PM | Last reply by Daniel Janik - Wednesday, March 21, 2018 10:16 PM
-
0 Votes
Facet: Database Ownership Chaining
ownership chaining? The facet's value is set to "False" on my database but "internal ownership chaining" still functions. ...Answered | 2 Replies | 465 Views | Created by lb483 - Friday, February 10, 2017 12:18 PM | Last reply by Dan Guzman - Friday, February 10, 2017 1:27 PM -
0 Votes
cross database ownership chaining on database view
ON GO ALTER DATABASE [Test1] SET DB_CHAINING ON GO USE [TestDB] CREATE ROLE [Role1] AUTHORIZATION ...Proposed | 2 Replies | 8275 Views | Created by Johnson Chong - Thursday, April 9, 2009 11:07 AM | Last reply by Johnson Chong - Friday, April 10, 2009 1:14 AM -
0 Votes
cross database ownership chaining
i have a database with cross database ownership chaining enabled. data base was detached and reatached as a result owner changed from sa to account that was ...Answered | 1 Replies | 6736 Views | Created by metelitg - Monday, March 10, 2008 6:10 PM | Last reply by Jonathan Kehayias - Tuesday, March 11, 2008 12:33 AM -
0 Votes
ownership chaining
This returns many records with several fields... I do not see anything in there regarding ownership chaining. ThanksAnswered | 7 Replies | 6051 Views | Created by arkiboys - Tuesday, July 1, 2008 1:15 PM | Last reply by Orlando Colamatteo (Live) - Saturday, August 3, 2013 11:35 AM -
0 Votes
"Cross database ownership chaining"
Ownership Chaining By default, all database objects have owners. When an object such as a view, a stored procedure, or a user-defined function references another ...Answered | 2 Replies | 8803 Views | Created by edm2 - Thursday, October 5, 2006 2:29 PM | Last reply by JoeyDj - Thursday, October 5, 2006 8:34 PM -
3 Votes
SELECT permission denied with ownership chaining on
Hi, I got the same error message if I disable the cross-database ownership chaining. “The SELECT permission was denied ...Answered | 13 Replies | 3897 Views | Created by AllenN - Wednesday, June 18, 2014 4:56 AM | Last reply by Andreas.Wolter - Thursday, June 19, 2014 9:59 PM -
0 Votes
Ownership chaining
VIEW [interface].[MyTestView] AS SELECT col1, ...Answered | 3 Replies | 6947 Views | Created by Mansos - Monday, November 15, 2010 2:57 PM | Last reply by Mansos - Monday, November 15, 2010 3:28 PM -
0 Votes
cross db ownership chaining Option
security Tab -> tick the check box - cross db ownership chainingAnswered | 7 Replies | 6397 Views | Created by Varinder Sandhu - Friday, June 11, 2010 10:13 AM | Last reply by Tom Phillips - Monday, June 14, 2010 2:06 PM -
1 Votes
sys.tables and cross-database ownership chaining
The behavior you are seeing is by design. Ownership chaining is essentially bypassing the select acces check on table B because the view in A has the same ...Answered | 2 Replies | 6677 Views | Created by J3456 - Thursday, November 12, 2009 2:01 PM | Last reply by Steven Gott - MS - Thursday, November 12, 2009 7:42 PM -
0 Votes
Schemas, ownership chaining, and performance
Question: will the performance of the Select be "diminished" by ownership chaining between the schemas? (Or is OC not an issue because the schemas are owned ...Unanswered | 3 Replies | 4393 Views | Created by edm2 - Friday, March 12, 2010 5:16 PM | Last reply by RobNicholson, MCSM - Thursday, March 18, 2010 10:14 AM -
2 Votes
Database Ownership Chaining Across Servers
linked server is an Oracle instance. Or an Access database. How would ownership chaining work in this case? When you have a linked server, originating SQL Server ...Answered | 4 Replies | 1066 Views | Created by Jeelani Kamal - Thursday, April 24, 2014 8:26 PM | Last reply by Erland Sommarskog - Friday, April 25, 2014 7:17 AM -
3 Votes
Stored procedure and ownership chaining
SELECT * FROM table_3 GO -- Break Ownership chaining by making the SP owner a different user -- CREATE USER [usr_proc_owner] WITHOUT ...Answered | 6 Replies | 1367 Views | Created by SQLAd - Monday, December 8, 2014 2:17 PM | Last reply by SQLAd - Tuesday, December 9, 2014 2:22 PM -
1 Votes
Issue with Cross Database Ownership Chaining.
vulnerability with cross-databases ownership chaining is. http://www.sommarskog.se/grantperm.html This is quite aAnswered | 6 Replies | 686 Views | Created by ChrisRDBA - Monday, May 7, 2018 10:57 PM | Last reply by ChrisRDBA - Tuesday, May 8, 2018 2:30 PM -
1 Votes
Cross DB Ownership Chaining - Indexed Tables/Views
by dropping/disabling the indizes - afterwards I could create them again. Question (refering to Cross DB Ownership Chaining): Will it make a ...Answered | 2 Replies | 481 Views | Created by Diese - Thursday, March 30, 2017 2:46 PM | Last reply by TiborK - Friday, March 31, 2017 7:07 AM -
0 Votes
Cross Database Ownership Chaining not working with AD Group
do you know if there is a problem using AD Groups in Cross Database O C? What does cross-database ownership chaining has to do with it? Are you ...Proposed | 4 Replies | 1194 Views | Created by Kilsgaard - Tuesday, June 9, 2020 1:17 PM | Last reply by Lily Lii - Thursday, June 11, 2020 9:52 AM -
0 Votes
Cross database ownership chaining not working with windows group
Cross Database Ownership Chaining (CDOC for short) seems to require that the caller has access toAnswered | 3 Replies | 6739 Views | Created by Brian Amersi - Tuesday, March 18, 2008 9:43 AM | Last reply by Brian Amersi - Wednesday, March 19, 2008 7:00 AM -
0 Votes
alter view
"alter view to update view" could mean many things. Here are a couple of interpretations: (1) Redefine a database view ...Proposed | 3 Replies | 353 Views | Created by sarmad jal - Wednesday, January 28, 2015 8:21 AM | Last reply by Cor Ligthert - Wednesday, February 4, 2015 11:44 AM -
0 Votes
select statement vs view
i saw a strange thing. when i am executing view as a select statement i am getting 7 rows displayed ,but when i execute the same select stamenet as a ...Answered | 2 Replies | 2168 Views | Created by anki2010 - Friday, November 4, 2011 3:37 PM | Last reply by anki2010 - Friday, November 4, 2011 3:54 PM -
2 Votes
Cross database ownership chaining not working - sql server 2014
GetExtract, Line 40 The SELECT permission was denied on the object 'LogStats', database 'Meta', schema 'dbo'. Cross db ownership is ...Answered | 6 Replies | 1599 Views | Created by Pedja Stojakovic - Tuesday, July 24, 2018 5:13 PM | Last reply by Erland Sommarskog - Wednesday, July 25, 2018 9:45 PM - Items 1 to 20 of 1036276 Next ›
No announcements
