By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

Security problem in Access 2000 - Admins user can't change query design

P: n/a
I create a new user and make them a member of Admins. I then log on as
that user and try to modify an existing query. I'm told that I don't
have the necessary permissions. The Admins group has full permissions
on the query.

The new user can create new queries and modify them, but the database
owner cannot modify these queries, even though the database owner
explicitly had Administer permission on them.

A possible related issue is that the owner of query objects cannot
change owner to someone else.

The new user can change the design of forms and reports.

Any ideas.

--
Regards.
Richard.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mon, 29 Nov 2004 06:56:36 GMT, Richard Sherratt
<ri**************@NOTHINGHEREbrunsley.com.au> wrote:
I create a new user and make them a member of Admins. I then log on as
that user and try to modify an existing query. I'm told that I don't
have the necessary permissions. The Admins group has full permissions
on the query.

The new user can create new queries and modify them, but the database
owner cannot modify these queries, even though the database owner
explicitly had Administer permission on them.

A possible related issue is that the owner of query objects cannot
change owner to someone else.

The new user can change the design of forms and reports.

Any ideas.

--
Regards.
Richard.


Hi
Is this an owner-access query? I seem to remember that these can only
be modified by the owner, though I could be wrong.
David

Nov 13 '05 #2

P: n/a
On 30 Nov 2004 14:54:17 -0600, d.***************@blueyonder.co.uk
(David Schofield) wrote:

<snip>
Is this an owner-access query? I seem to remember that these can only
be modified by the owner, though I could be wrong.


Ding!

Thanks :-)

--
Regards.
Richard.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.