Re: No user with admin permissions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

There is always *some* user that has the necessary permissions - i.e. the
owner.

You need to login as the owner.

Generally, a person in the Admins group does have permission to change
security.

You didn't answer whether the owner is showing as blank (never heard of
that) or <unknown>

If it is unknown, then you aren't using the correct mdw, or the owner was
deleted from the mdw.

You can re-create that user, making sure you use the same name/PID, or
restore the mdw from a backup.

--
Joan Wild
Microsoft Access MVP

CrystalJim wrote:
I agree, the Admins group does have a user, the Super User. However,
the Admins group has no permissions on the database and that is
possible. And, it is possible to have a user who does not have admin
type permissions, that is, no user who can change security, a user
who has all possible permissions. That is the status of my client's
database. I do not know how it happened; I just need to know how to
fix it.

To rephrase my question, how can I unsecure a database when no user
or group has permissions to change security?


Thanks,

Jim




"Joan Wild" wrote:


CrystalJim wrote:

Can you guess what happened? Right, the super user no longer has
permissions for anything. Also, when I looked to see who owned the
database - no owner was listed, not admin - not anyone, just a
blank.

Blank or <unknown>?

It's impossible to have a mdw with zero users in the Admins Group.


.

Relevant Pages

  • Re: I excluded myself from administrators of a db
    ... I think it worked because the original file was not properly secured; otherwise security could be circumvented simply by copying into a new database as you have done. ... There is an Admin user, who is the default user, and who is by default a member of the Users group and the Admins group. ... Both groups have full permissions by default, but only members of the Admins group may create and delete users/groups, change user/group permissions, etc. ...
    (microsoft.public.access.security)
  • Re: stored procedures and permissions
    ... If Todd is new and can't alter any objects what are the ... and "what permissions does y need" rather then thinking of x ... Microsoft SQL Server 2000 SP3 Security Features and Best ... >> Server checks permissions on each object where the owner is ...
    (microsoft.public.sqlserver.security)
  • Re: permissions to import after a new workgroup file?
    ... To import as a new owner from a previous owner, ... for the objects in the original database. ... Normally permissions are assigned via Groups. ... You shouldn't be altering security measures with the "default workgroup". ...
    (microsoft.public.access.security)
  • RE: Project Update Capability
    ... I would check the user/group security that these users are in. ... Under the Global permissions, uncheck the ... > Although I am still the owner of the projects created, when I logon as ...
    (microsoft.public.project.pro_and_server)
  • Re: security for 100+ user and dbs without having to signin
    ... The owner of a DB can always give themselves permissions. ... by someone unaware of security, then likely they were logged in as ... > database remove all unnecessary permissions from ...
    (microsoft.public.access.security)