Permission-Table Data, Table Object

nikeman77

hi

anyone knows when to use table, table data in permission table setup?

mohana_cse06

Difference between Table and table Data is
Table - This is the Table Objects themselves, the definition of the tables, the keys, and the trigger codes.
TableData - This refers to the data stored in the tables. This is what gives you permission to read or write the data in the database.

Generally we give access to all tables by setting 0
and restrict users by appropriate table data (in reading,inserting,modifying and deleting)

nikeman77

hi mohana,

but its really not so useful to grant them all access to table object, we can grant access to other object and restrict them in table data level as your recommendation.

may i check any websites/ references/ documentation from anywhere to read further?

mohana_cse06

Check the existing roles in cronus database how they are mapped..