Security Enhanced Objects

[Guest]

I have secured a database. When I initially ran the wizard, the security
wizard report showed me all security enhanced objects, excluding one table
called "Administrators". I am unsure why it skipped over this table. Now
when I pull this table up it can be modified by all users and I get an error
whenever I try to add security to it.

Is there anyway to add this as a security enhanced object or do I have to
start over? How would I secure additional tables or queries that I add to
the database?

 

[Joan Wild]

You should be able to modify the security on this object, if you are the one
that secured the database.

When you login and go to Tools, security, user and group permissions, change
owner tab...what is listed as the owner of the 'Administrators' table?

What happens when you try to change the owner to your username?

What errors do you get when you try to apply permissions to it?

 

[Guest]

You were absolutely right, the owner was set to the "admin". I went logged
in as the "admin" and changed the ownership over to my username. Simple fix.


Thanks a lot.