|
Focus on SQL Server User Rights & Permissions
Welcome to SQLsmarts, Idera’s monthly newsletter
for SQL Server Professionals! We welcome your questions,
comments or suggestions.
Email us at SQLsmartseditor@Idera.com.
|
|
| SQL Server
News |
Understanding SQL Server 2005 User Permissions
SQL Server 2005 introduces several enhancements that give database managers more control over who has
access to sensitive SQL Server data. These new features provide powerful, time-saving “granular permission
control” but can also be dangerous if not used appropriately.
In SQL Server 2005, permissions can be given at the server level, database level, schema level, object level, and principal level. Now, when you grant permission at a schema level, the principal will get that permission on all objects in the specified schema – not just on one object. This new capability eliminates having to assign permissions to each object individually and, therefore, can save a lot of time. But, if you are not thinking ahead, some users may end up with access rights that you didn’t want them to have.
Read more:
“Granting Permissions in SQL Server 2005” >>
Written by: Adam Machanic, Contributor
Publisher: SearchSQLServer.com
|
| Product Announcement |
Just released: SQLsecure v1.2
Assess security risks & audit access rights
Idera SQLsecure analyzes access rights across SQL Server, Active Directory and Windows to calculate the effective permissions for any user, object or access control. With SQLsecure you can more easily keep users in check, eliminate security holes, meet compliance requirements, and ensure the integrity of your company’s SQL Server data.
SQLsecure helps you:
- View user and group effective access rights
- View inherited rights on server or database objects
- Highlight concerns such as suspect Windows accounts
- Track changes to your SQL Server security model
- Satisfy audit requirements with entitlement reports
|
- SQL Server Security Scorecard: Fast, easy summary that analyzes five critical SQL Server security risks and lets you know if your SQL Servers pass or fail. Drill down for more information on each item and for suggestions on how to eliminate the security risk.
- Enhanced permissions analysis: See exactly how and where user rights were granted, making it easier to pinpoint where changes need to be made to close security exposures.
- Windows Account Analysis: View all logins on the target server, as well as any suspect Windows Accounts or Groups
- Enhanced Reporting: 10+ pre-defined reports support compliance and standards reporting requirements, such as ISO and COBIT
- Enhanced Collection Wizard: Customize the security data that is collected on each SQL Server
|
|
|
Read more about SQLsecure version 1.2 
Try SQLsecure now, Free for 14 days
|
| SQL Server 2005 Migration |
|
Migrating to SQL Server 2005? Idera can help!
Idera provides a comprehensive line of award-winning tools for SQL Server that will help you ensure a smooth migration to SQL Server 2005. What’s more, after you migrate, you’ll already have the tools you need to monitor, manage and secure your new SQL Server 2005 environment.
Here’s a summary of how Idera’s tools for SQL Server can help: |
- SQLscaler: Conduct baseline and database inflation testing to ensure proper functionality and performance in the new environment.
- SQL diagnostic manager: Identify consolidation opportunities, and monitor for worst-performing code after your migration.
- SQL mobile manager: Monitor your SQL Servers from a Windows Mobile device post-upgrade and take corrective action anytime, anywhere if problems arise.
- SQLsecure: Evaluate your security model pre- and post-upgrade to ensure users’ have appropriate access rights.
- SQLsafe: Develop and test a comprehensive disaster recovery plan in the event that something goes wrong during your migration.
- SQL change manager: Capture your data model as part of your disaster recovery plan, and easily check or re-synch objects against the original to ensure your data model remains intact.
- SQL compliance manager: Monitor your SQL Servers for failures, such as access right denials, to troubleshoot configuration and permission issues after migration.
|
Visit Idera’s new SQL Server 2005 Migration Resource Center >>
Download the new whitepaper >>
Migration to SQL Server 2005: How Idera’s Tools for SQL Server Can Help |
| Webcasts |
|
LIVE WEBCAST: SQL Server 2005 Reporting Services
Thursday, March 15, 2007
11:30 AM – 1:00 PM Central
Register now >>
Reporting Services was released in 2004 as part of SQL Server 2000. Using Reporting Services will help you deliver information to the right people in a variety of formats and channels. SQL Server 2005 offers an expanded version of Reporting Services and also has an added feature called Report Builder.
Attend this live webcast with Scalability Experts and Idera to learn more about SQL Server 2005 Reporting Services and the new SQL Server 2005 Report Builder tool. You’ll learn how to leverage these tools to help you create reports and get information to the right people faster.
|
|
|
|
|
Live Webcast: How to Use SQL Server Upgrade Advisor *
Tuesday, March 20, 2007
3 PM Eastern | 2 PM Central | 1 PM Mountain | 12 PM Pacific
Register now >>
SQL Server Upgrade Advisor is a free tool in SQL Server 2005, which will analyze your SQL Server environment and pinpoint any issues that may arise during migration. Attend this webcast, hosted by Scalability Experts and Idera, to learn more about SQL Server Upgrade Advisor and how to use it. You’ll also learn more about how Idera’s tools for SQL Server can help streamline your migration to SQL Server 2005.
*This webcast was originally presented in January 2007, this event will be a rebroadcast through SSWUG.org. A Scalability Experts staff member will be on hand during this event to answer your questions.
|
|
|
|
|
Check out these On-Demand Webcasts:
|
| Feedback |
|
We want to hear from you!
Do you have an interesting story
about how Idera product(s) have helped you? Want to share
a product tip, trick or hint? Have product suggestions or
questions?
Your feedback helps us ensure that our newsletter is helpful!
You may even find your input published here in future newsletters.
Please send your comments and suggestions to SQLsmartseditor@idera.com
|
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Live Webcasts:
Visit Idera at these upcoming events:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
