Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Policy Based Management - Encryption

Author  Topic 

swoozie
Starting Member

25 Posts

Posted - 2014-05-29 : 11:51:13
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?

sz1
Aged Yak Warrior

555 Posts

Posted - 2014-06-17 : 07:22:56
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

25 Posts

Posted - 2014-06-17 : 11:08:41
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!
Go to Top of Page

swoozie
Starting Member

25 Posts

Posted - 2014-08-08 : 10:18:52
I have determined that the answer to my question does not exist. We just guess what facets and values are. So I have resolved to writing alot of ExecuteSQL() PBMS.
Go to Top of Page
   

- Advertisement -