Page History
...
There may be times when it seems as though the permissions for a user or table have changed drastically when no changes have actually occurred. The following table lists some of the possible causes:
| Cause | Solution |
|---|---|
| A user or table is deleted and then the same name is used again in the future. | Make sure that best practices are used when adding and deleting user and table names, or properly note the change to avoid confusion. |
| A user or table name is changed | Properly note the change to avoid confusion. |
| A user or table is deleted from the system | Properly note the change to avoid confusion. |
SQL Secure allows you to audit all users and object permissions on SQL Server instances that have been registered with SQL Secure. For more information about SQL Server permissions, see Microsoft Books Online.
...