|
Author:
Author Bio:
Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...
|
|
|
Understanding SQL Server Securables
Security in SQL 2005 and beyond includes the concept of securables, allowing the DBA more granularity when assigning permissions. It also means that our old friend sp_helprotect doesn't always return all the information and we need to look to a new resource instead. Presented by MVP Brian Kelley.
|
Video Information
|
Publish Date:
|
July 27, 2009
|
Length:
|
5:35
|
Skill Level:
|
100
|
Rating:
|
4.22 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- Why is sp_helprotect no longer the recommended solution for viewing permissions?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
Great video Brian. Keep uploading the security related videos. I know you have the expertise on that.
|
|
Shamshad Ali on 7/28/2009
how to add a user with read only permissions? i need some help on SQL Server 2005 for this purpose. Plz help. Your current video is great. keep it up.
|
|
|
Brief and adequate. Loved it!
|
|
Carla Wilson on 7/28/2009
Excellent information, but the small window size/size of text was hard to read. Zooming in was great! Is it possible to start zoomed in a little more?
|
|
|
With all the DMVs in SQL 2005 and above, it's always great to get a tip on how to use one. The sys.database_permissions DMV is extremely useful. Great movie!
|
|
|
Shamshad Ali,
You can GRANT SELECT against the schema or even the database itself (GRANT SELECT ON DATABASE::MyDatabase TO MyUser or GRANT SELECT ON SCHEMA::Dbo TO MyUser). You could also go the old route of making the user a member of the db_datareader role. I usually recommend against db_datareader because it gives permissions implicitly, meaning if you query sys.database_permissions, you won't see the access.
|
|
|
Great example
|
|
|
Very Good Brian, I really like your Security videos in particular, but including the code for downloading would have been nice...
|
|
|
very good
|
|
|
very good!
|
|
|
I have SO needed this! I will start using this today - thanks!!
|
|
|
speaker is too speaks too quickly
|
|
|
I love the DMV (Data Management View). Worth watching just for that!
|
|
|
|
|
|
|