Re: Object permissions

I've lost the original post here. Who is the owner of the query? What
permissions does the owner have on the underlying tables? What permissions
does the user have on the query; on the tables.

What is the error message you get when trying to run as the user?


--
Joan Wild
Microsoft Access MVP

Scott wrote:
Thanks Joan, but I have given the user explicit as well as implicit
modify rights on this query. Also, it is the only one that is giving
me a problem. I have others that work fine. That is the strange thing
that has me puzzled. It is set up the same as my other queries as far
as permissions go. I know it's hard to get a grasp of the entire
picture without seeing all of the security settings, but I agree with
you....modify permissions should enable the user to set the sql of
the query at runtime but they don't in this case. I've tried deleting
the query and setting up another one but get the same error. I
noticed you said that the owner will be the user running the code.
But this isn't the case here. Would running code that modifies an
object change the object's owner?

Also, regardless of the code...shouldn't I (current owner of the
query) be able to pass ownership to another user?

"Joan Wild" wrote:

Setting WITH OWNERACCESS OPTION in code is pointless, since the
owner in this case will the user running it and they may not
(probably don't have) permission on the underlying tables. You
should be able to get it working if you grant modify permission on
the qryAttendanceActual query.

--
Joan Wild
Microsoft Access MVP

Scott wrote:
Thank you for the replies, but it really doesn't matter whether I'm
trying to change the owner to a group or an individual, it still
says that I don not have the permission to change the object's
owner....but I am the owner of that object, so I should have the
permission to change it. Also, I do set the querie's run permissions
to 'owners' in the sql statement each time the code runs, but it
isn't that the person running the code doesn't have permission to
run the query, they can actually open the query once the sql is
set. They just can't set the sql itself. Below is the code used to
set the sql for the query:

'set query for attendance logs
strSQLAttendance = _
"SELECT tblPayroll.CompNo, Month([Date]) AS [Month],
Day([Date]) AS [Day], " & _
"tblPayroll.Date, Sum(tblPayrollDetails.Hrs) AS
SumOfHrs, " & _
"tblEmployees.EmployeeLastName,
tblEmployees.EmployeeFirstName, " & _
"tblPayroll.Reason, First(tblPayroll.HrsMissed)
AS FirstOfHrsMissed, " & _
"tblAttendanceReasonCodes.AbsenceTypeID " & _
"FROM ((tblPayroll INNER JOIN tblEmployees ON
tblPayroll.CompNo = tblEmployees.CompNo) " & _
"LEFT JOIN tblPayrollDetails ON tblPayroll.PayID
= tblPayrollDetails.PayID) " & _
"INNER JOIN tblAttendanceReasonCodes ON
tblPayroll.Reason = " & _
"tblAttendanceReasonCodes.AttendanceReasonCodeID
" & _ "WHERE (((tblEmployees.EmployeeNo) =" & EmpNo & ")
And ((Year([Date])) =" & _
varYear & ")) " & _
"GROUP BY tblPayroll.CompNo, Month([Date]), Day([Date]),
tblPayroll.Date, " & _
"tblEmployees.EmployeeLastName,
tblEmployees.EmployeeFirstName, tblPayroll.Reason, " & _
"tblAttendanceReasonCodes.AbsenceTypeID " & _
"ORDER BY tblEmployees.EmployeeLastName,
tblEmployees.EmployeeFirstName " & _
"WITH OWNERACCESS OPTION "
Set objQDF = CurrentDb().QueryDefs("qryAttendanceActual")
objQDF.SQL = strSQLAttendance
objQDF.Close

"'69 Camaro" wrote:

Hi, Joan.

You can, and I have, made a group the owner of an object.

Doh! Thanks for the correction. I could have sworn I've done the
same thing as Scott and received the same error message because I
accidentally grabbed the group name, not the user name when I
assigned the new owner. I can see that there's no such problem
when I try it now.

Thanks.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and
tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for
contact info.


"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:upJGqprIHHA.5104@xxxxxxxxxxxxxxxxxxxxxxx
'69 Camaro wrote:
So I tried to change the object's owner to the group "Admins"
. . .
Am I missing something here?

Yes. You may assign one -- and only one -- user as the new owner
of the object. A group is not a user. A group contains zero to
many users as members, so a group is related conceptually to
users, but a group can't substitute for a user as the "owner."

You can, and I have, made a group the owner of an object. Doesn't
matter in Scott's case, but I thought I'd point out that this can
be done.

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: Object permissions
    ... only the owner can set the RWOP property on a query. ... Once I removed that line from the sql, ... you grant modify permission on the qryAttendanceActual query. ...
    (microsoft.public.access.security)
  • Re: What commands can a user execute
    ... simple security query rather than BOL. ... example would be the command UPDATE STATISTICS. ... ALTER permissions on the table or view. ... you could retrieve this with a query from SQL Server rather than Books ...
    (microsoft.public.sqlserver.security)
  • Re: rwop
    ... Your clarification of rwop does help me think through the process, ... If my query doesn't ... users from entering data, but no, they will have owner's permissions. ... permissions of the owner. ...
    (microsoft.public.access.security)
  • Re: Security without signon
    ... I have never had to give the query owner explicit permissions on the tables. ... Your super user should not need to inherit any permissions from any group, ...
    (microsoft.public.access.security)
  • Re: Pass Through Query Question
    ... I did some more searching and found the answer from Joan Wild on the ... security group - The users need to have write permissions to the pass ... >I am using VBA code to update teh SQL of a pass through query to SQL ...
    (microsoft.public.access.modulesdaovba)