SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Policy Based Management - Encryption
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

swoozie
Starting Member

USA
18 Posts

Posted - 05/29/2014 :  11:51:13  Show Profile  Reply with Quote
It has taken sometime to figure this PBM thing out. There is still very little information. I would really like a reference guide that lists the Facet, the Properties, and at least some of or example of the anticipated values. most of what I have created have been using the ExecuteSQL script.

On that note, I am now working on checking encryption properties. These seem straight forwared enough, however I am not finding anything but a manual way to checke the Protocol Propertieds on an instance, Force Encryption = YES/NO

Any suggestions?

Edited by - swoozie on 06/17/2014 11:06:49

sz1
Constraint Violating Yak Guru

United Kingdom
392 Posts

Posted - 06/17/2014 :  07:22:56  Show Profile  Reply with Quote
First thing that came up in Google
http://msdn.microsoft.com/en-gb/library/ms189121.aspx

You need to have the roles to a certain degree predefined in order to allow the correct access to your DB. That means for example giving correct permissions to certain DB objects for reporting purposes where Grant Select would be selected for instance on the Sales Tables(s).

We are the creators of our own reality!
Go to Top of Page

swoozie
Starting Member

USA
18 Posts

Posted - 06/17/2014 :  11:08:41  Show Profile  Reply with Quote
quote:
Originally posted by sz1

First thing that came up in Google
http://msdn.microsoft.com/en-gb/library/ms189121.aspx

You need to have the roles to a certain degree predefined in order to allow the correct access to your DB. That means for example giving correct permissions to certain DB objects for reporting purposes where Grant Select would be selected for instance on the Sales Tables(s).

We are the creators of our own reality!




Thanks, but my needs have changed since I first posted this, and I have now edited the question to be more to my needs. Thanks!

Edited by - swoozie on 07/15/2014 15:23:18
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000