Table Information table

navnetnavnet Member Posts: 57
Roles have been limited to some users. But I wanted to give arole which allows Taking Backup (FBK) and Restoring it. The current roles says "You do not have access to Table Information table "

I dont see any Table Information table thru Object Designer. Please help. which Table access is to be given for this role.

Answers

  • matttraxmatttrax Member Posts: 2,309
    You won't find it in Object Designer. It's a system table. It contains what you see when you go to File --> Database --> Information and click on Tables.

    When adding permission for the table to the role you'll find it is object ID 2000000028.
Sign In or Register to comment.