Help Center/ Data Lake Insight/ FAQs/ DLI Databases and Tables/ Do I Need to to Regrant Permissions to Users and Projects After Deleting and Recreating a Table With the Same Name?
Updated on 2024-11-15 GMT+08:00

Do I Need to to Regrant Permissions to Users and Projects After Deleting and Recreating a Table With the Same Name?

Scenario

User A created the testTable table in a database through a SQL job and granted user B the permission to insert and delete table data. User A deleted the testTable table and created a new testTable table. If user A wants user B to retain the insert and delete permission, user A needs to grant the permissions to user B again.

Possible Causes

After a table is deleted, the table permissions are not retained. You need to grant permissions to a user or project.

Solution

Operations to grant permissions to a user or project are as follows:

  1. On the left of the management console, choose Data Management > Databases and Tables.
  2. Click the database name whose table permission is to be granted. The table management page of the database is displayed.
  3. Locate the row of the target table and click Permissions in the Operation column.
  4. On the displayed page, click Grant Permission in the upper right corner.
  5. In the displayed Grant Permission dialog box, select the required permissions.
  6. Click OK.