the select permission was denied on the object 'user property' database, schema 'dbo'

(0) Share

Report

Posted on by Community Member

I restored NAV 2015 backup from live production to my test environment in which I currently exist as a user. When I want to access the database, it displayed the error message "the select permission was denied on the object 'user property' database, schema 'dbo'". I ran SQL script to delete all users. Yet, I cannot access the database.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

run this command in SQL query and check

use [Your_NAV_Database]

go

grant select on [user property] to public

go

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mohana,

I ran the script and tried to access the database, but the same problem persist

Was this reply helpful? Yes No