question

mb192 avatar image
0 Votes"
mb192 asked AmeliaGu-msft commented

Unknown Permission type CRVW

I am running a Powershell script (SQL PowerDoc) and I'm getting this error on some servers.

Also Unknown Permission type CRCF

I'm not sure where to look to find this issue on the server to fix it. Any suggestions?

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi subnet192,

How are things going on? Do the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered mb192 commented

CRVW = CREATE VIEW, CRCF = CREATE CERTITICATES-

These codes appear in the column sys.database_permissions.type. I don't know about SQL PowerDoc, but apparently it does not know about this permissions (which looks like a shortcoming to me).

Is this something from Microsoft or a third party tool?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Powershell script /module for documenting sql environment. Hasn't been updated in a while but I'm running this against an older sql server... Thanks for your input. I'll see if I can modify the tool...

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered mb192 commented

Hi subnet192,

In addition, you can try to use Microsoft Assessment and Planning toolkit (MAP) to discovery information about your Windows deployments and SQL Server instances, and automate the collection of inventory data about your database landscape. Please refer to this tutorial which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, trying it right now.

0 Votes 0 ·