Re: database split before or after security?

I always have a user as owner, not a group. I'm not sure the value in
having a group as owner.

--
Joan Wild
Microsoft Access MVP

hireagenius via AccessMonster.com wrote:
hireagenius wrote:
Joan,
Many thanks for your response, once again.

As I go through the user and group permissions, I may have made an
error.

The owner is "Developer" and is a member of Admins Group and
Developer Group, both groups have identical security permissions.

The user "Developer" has Open/Run permissions on the database (and
forms) but not the tables or queries. Additionally, the Admins
Group nor the Developer Group has Open/Run permissions on the tables
or queries. It appears that no one has Open/Run permissions on the
tables or queries.

However, as Developer, I ran the queries and they worked fine. Is
there something I am missing regarding Open/Run permissions? I did
not knowingly revoke these permissions.

Second question - Should I change the owner of objects from the
Developer User to the Developer Group?

Thank you
Charlie

Whoops Joan - I asked a question I could have answered easily by
looking in the Help file. Open/Run permissions doesn't apply to
tables and queries.

However - if anyone would like to address the 2nd question regarding
granting ownership to the Developer Group rather than the Developer
User, I would be much obliged.

As always,
Thank you kindly.
Charlie


Hi Access Heros,
I created a new database in Access 2003. I created a new workgroup
[quoted text clipped - 22 lines]
need to proceed with creating groups and assigning the permissions
to those groups for each database.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200603/1


.

Relevant Pages

  • Re: database split before or after security?
    ... As I go through the user and group permissions, I may have made an error. ... The owner is "Developer" and is a member of Admins Group and Developer Group, ... Group has Open/Run permissions on the tables or queries. ...
    (microsoft.public.access.security)
  • db_ddladmin database role and dbo security
    ... I have a developer that I gave db_ddladmin role so he ... can create objects by specifying DBO as the owner. ... execute the stored proc because he didn't have permission ...
    (microsoft.public.sqlserver.security)
  • Re: [kde] Associaton configuration in Konqueror
    ... and if there is that its owner is also your user and it is at least "rw" ... "touch" means it will only modify the access timestamp, ... Kevin Krammer, KDE developer, xdg-utils developer ...
    (KDE)
  • User rights problem
    ... "Specified owner name 'dbo' either does not exist or you do not have ... rights which i should give to the "developer" login for donig so. ...
    (microsoft.public.sqlserver.security)