Home | Previous Page | Next Page   The Table Option > Displaying Table Information >

Displaying Table-Level Privileges

Figure 96 shows the kind of table-level access-privileges information that you see when you select the Privileges option for the cust_calls table.

Figure 96. Display of Privileges Information
User    Select   Update   Insert   Delete   Index   Alter

public  All      All      Yes      Yes      Yes     No

Unless your login is listed separately, you have the privileges given for public (a general category for all users).

If you want information about database-level privileges, use a SELECT statement to access the sysusers system catalog table.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]