Re: database split before or after security?

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: Where To Put Data?
    ... Russell's solution is to change the permissions on ... on the all users app data folder and create a subfolder ... Easier on the developer, and there is no need to have an NT system to test ... Every user use the same settings. ...
    (microsoft.public.vb.general.discussion)
  • Re: Roles - Users
    ... Developer is a domain level group. ... On the database server, there are legacy ... association with the legacy domain permissions on the server. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Roles - Users
    ... Developer is a domain level group. ... association with the legacy domain permissions on the server. ... Windows groups he is a member of. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions exception saving app config
    ... developer runs the same code in Visual Studio debug he receives a ... At the file/folder level he has full permissions and I would think we have ... the same default code access security. ... In an attempt to fix the problem, I had a freak caspol accident (I think it ...
    (microsoft.public.dotnet.framework)
  • 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. ... I created a new database in Access 2003. ...
    (microsoft.public.access.security)