SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Tim Mitchell
Author:

Author Bio:
Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.
Update SQL Permissions using SMO

Update SQL Permissions using SMO

It's surprisingly easy to set permissions in an object based way using SQL Management Objects (SMO). Tim Mitchell shows you how to use the ObjectPermissionSet to hold the permissions and then apply them to a specified object. If you're new to SMO check out Tim's other videos to learn SMO from the beginning!

Video Information
Publish Date:
September 10, 2008
Length:
2:16
Skill Level:
200
Rating:
4.24 out of 5

After watching you should be able to answer these questions:
  1. What is the ObjectPermissionSet object used for?

  2. What method of a stored procedure object is used to apply new permissions?
You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
hades on 2/19/2009
is it possible to Script out the T-SQL code with SMO scripter and generate something like this: GRANT EXECUTE ON [dbo].[upsmyproc] TO [MYROLEROLE] AS [dbo] GO

Lou Gallo on 6/4/2009
Nice eye-opener. Just would be good to indicate what dll's need to be referenced and what 'using' namespaces are necessary.

Josh Blair on 6/4/2009
Nice and clear explanation. Thanks.



Must Be Logged In

References
Download the code from this video

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions