When reverse engineer a database. Some users are granted explicitly permissions to objects are having associated schemas materialized. However, the "user" and associated permissions are not being materialized. The database in SSMS show User and their permission but in the Toad after reverse engineering, the User does not have anything. When viewed in SSMS the permissions and associated users group do exist.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center