Blog - comments

Hi Olivier, That's a good question. I think the reason is that data_object_id cannot identify a segm...
@toms and others: -- create your output: iozone -Rab output.xls /u01-- scp off to desptop, or to loc...
Scott
Hi Frank,Very interesting post ! Congratulations for starting an Oracle 7 ; did you virtualize an HP...
Olivier Berthommé
Belle démo, je crois que je vais te la piquer ! Mais as tu essayé un DBCC CHECKCONSTRAINTS ou un DBC...
SQLpro

Thanks Franck , you are a savior! Great article indeed.

Prasad
Blog Stephane Haby SQL Server 2012: new permissions

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

SQL Server 2012: new permissions

For this end of the year, I decided to present you the new permissions on SQL Server 2012.

How to have a list of all permissions ?

It's very simple with this query:

SELECT * FROM sys.fn_builtin_permissions('')

SQL 2008 R2

SQL 2012

With this comparison, you can see that there are 19 new permissions in SQL Server 2012.

To have a great overview, I prefer use this query ordering by the class description:

SELECT class_desc,count(*) as Permission_Number FROM sys.fn_builtin_permissions('') group by class_desc;

Just 2 classes have new permissions: SERVER and SCHEMA. But 3 new classes appeared: AVAILABILITY GROUP, SERVER ROLE and SEARCH PROPERTY LIST.

Let's go for the details...

Class SERVER

Query:

SELECT * FROM sys.fn_builtin_permissions('') where class_desc='SERVER';

Result:

These 5 new permissions are for the new features AlwaysOnUser-Defined Server Role and Extended Events.

Class SCHEMA

Query:SELECT * FROM sys.fn_builtin_permissions('') where class_desc='SERVER';

Result:

This new permission is for the new feature Sequence

Class AVAILABILITY GROUP

Query:SELECT * FROM sys.fn_builtin_permissions('') where class_desc='AVAILABILITY GROUP';

Result:

These 4 new permissions are for the new High Availability feature AlwaysOn.

Class SERVER ROLE

Query:SELECT * FROM sys.fn_builtin_permissions('') where class_desc='SERVER ROLE';

Result:

These 4 new permissions are for the new feature User defined Server Role.

You can found an article of this feature here

Class SEARCH PROPERTIES LIST

Query:SELECT * FROM sys.fn_builtin_permissions('') where class_desc='SEARCH PROPERTIES LIST';

Result:

These 5 new permissions are for the enhancement of Full-text.

Search properties list is used to specify one or more search properties that you want to include in a full-text index.

Conclusion

19 new permissions for AlwaysOn, Sequence, User-defined Server Role, Extended Event and Search Properties List are created in this version of SQL Server.

This blog is to present you how to find permissions on SQL Server and I hope that can help you.Cool

Rate this blog entry:
1

Stéphane Haby is Delivery Manager and Senior Consultant at dbi Services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Certified Solutions Associate MCSA) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. He is also ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.


MCSA  MCSE  mvp

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Friday, 31 October 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter