ALTER Table and making changes to the columns removes permission settings from the table. (4234318)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

ALTER Table and making changes to the columns removes permission settings from the table.
Description

ALTER Table and making changes to the columns removes permission settings from the table.
Cause

Clicking back and forth between the column screen and the sql script screen may remove the GRANT permissions from the SQL script and cause the ALTER to remove the permissions from the table.
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix with a future release of Toad for SQL Server.
Defect ID

CR104049
Additional Information

Applies to version 5.6 and 5.7.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title