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

  • How to write a robots.txt file
  • How to increase php script execution time
  • Step by Step setting Transactional Replication in SQL Server 2008 R2
  • How To Send HTML Emails Using Php
  • How to create dynamic rss feed using php mysql
  • Php Array Pagination Script
  • Php For Beginners (Lesson 2)
  • Mysql Introduction - Php For Beginners - Lesson 10
  • Sessions in Php - Php For Beginners (Lesson 9)
  • How to create rss feed for static website

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.