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.
| 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/NOAny suggestions? |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-06-17 : 07:22:56
|
| First thing that came up in Googlehttp://msdn.microsoft.com/en-gb/library/ms189121.aspxYou 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! |
 |
|
|
swoozie
Starting Member
25 Posts |
Posted - 2014-06-17 : 11:08:41
|
quote:
Originally posted by sz1
First thing that came up in Googlehttp://msdn.microsoft.com/en-gb/library/ms189121.aspxYou 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! |
|
|
|
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. |
|
|
|
|
|
|
Policy Based Management - Encryption