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

  • SQL Server Profiler Identifying Deprecated Features
  • Php For Beginners (Lesson 6)
  • Php Array Pagination Script
  • Php For Beginners (Lesson 4d)
  • Php For Beginners (Lesson 5)
  • Php For Beginners (Lesson 4b)
  • Step by Step setting Transactional Replication in SQL Server 2008 R2
  • Mysql Php Pagination Script
  • Columnstore Indexes SQL 2016 in a nutshell
  • How to create dynamic rss feed using php mysql

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.