I am trying to give Read Only permissions on Log Shipping Secondary database. However, I am not able to do it as
it was a readonly/standby database.
I understand that adding the user as read only on Primary database adds it in the secondary database also, once the logs are copied to and restored on secondary.
I wanted to know if there is a way to add database level permissions other than this (I dont want to use sysadmin permissions to access secondary database.)