Change Table Permissions

R

Rupert

After a corruption in a database I have a user table who's permissions have been set to the dbengine see belo
so the system thinks its a system table and won't give me design permissions for i

Name: Company Informatio
Owner: Engin
All Permissons:
Inherit:
Permissions:
UserName: admi

I need to reset the permissions in code (or any other way) or be able to delete the table and re-create it as follows

Name: Cost Code
Owner: admi
All Permissons: 104831
Inherit:
Permissions: 104831
UserName: admin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to give someone permissions to use Paste Errors 0
Group Permission unsolicted changes 2
How to change a table owner 1
SAM Permissions Rest????? 0
Group Permissions and SQL 6
cannot delete linked table with owner 'Engine' 0
Permissons help 4
Admin owns table has full permissions but can't edit a cell or add records 10

Top