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

  • Php For Beginners (Lesson 5)
  • Php Array Pagination Script
  • Step by Step setting Transactional Replication in SQL Server 2008 R2
  • Php For Beginners (Lesson 7)
  • Php For Beginners (Lesson 4b)
  • How To Send HTML Emails Using Php
  • How to encrypt decrypt url or code in php
  • Php For Beginners (Lesson 8)
  • Common Microsoft SharePoint Server 2010 Installation Issues and Resolutions
  • Columnstore Indexes SQL 2016 in a nutshell

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.