Skills2Earn

28 January 2011

Enable Cross Database Ownership Chaining


Use DataBaseName
go
Alter Database DataBaseName
SET DB_chaining ON
go
EXEC sp_grantdbaccess 'GUEST'
go
Grant CONNECT to GUEST
go
Grant SELECT to Guest
go
Posted by Sameer MCITP at Friday, January 28, 2011
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Scripts

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

  • Factors Influencing Consumers Purchase Intentions towards Private Brands
  • Php For Beginners (Lesson 4c)
  • Step by Step setting Transactional Replication in SQL Server 2008 R2
  • Columnstore Indexes SQL 2016 in a nutshell
  • How to create dynamic rss feed using php mysql
  • Run ASP.NET Website with .NET Framework v1.1 on IIS 8 Windows Server 2012
  • Creating a connection to MySQL in PHP - Php For Beginners - Lesson 11
  • Php For Beginners (Lesson 1)
  • SQL Server Profiler Identifying Deprecated Features
  • Common Microsoft SharePoint Server 2010 Installation Issues and Resolutions

Categories

  • Databases (3)
  • IIS (1)
  • SQL Scripts (6)
  • SharePoint (3)
  • Storage (2)
  • VbScripts (1)
  • Windows Administration (1)
  • htaccess (3)
  • javascript (2)
  • mysql (3)
  • php for beginners (14)
  • php scripts (10)
  • robots.txt (1)
  • rss (2)

Pages

  • Home
  • About Us
  • Web Glossary

Twitter

Follow skills_2_earn on Twitter

Facebook

Contributors

  • Muhammad Bilal
  • Sameer MCITP

Archives

  • September (1)
  • April (1)
  • January (1)
  • November (1)
  • January (1)
  • June (1)
  • May (4)
  • April (1)
  • March (3)
  • February (3)
  • January (34)
  • December (5)
Simple theme. Powered by Blogger.