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

  • Step by Step setting Transactional Replication in SQL Server 2008 R2
  • Mysql Introduction - Php For Beginners - Lesson 10
  • How to create rss feed for static website
  • How to make thumbnails in php
  • Mysql Php Pagination Script
  • List all users of all databases with all roles
  • Php For Beginners (Lesson 5)
  • Columnstore Indexes SQL 2016 in a nutshell
  • Factors Influencing Consumers Purchase Intentions towards Private Brands
  • How to block an IP using htaccess

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.