Protected Sheets or other security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using excel, I have a ODBC connection and have a query set up that I would
like to be refreshed by sales people regularly, when they choose to. I would
prefer for security reasons that they cannot edit the query, only refresh the
query. The data is summarized in multiple pivot tables. I

s there a way to accomplish this by protecting the sheet that contains the
query? Or is there another option? Even if we establish Oracle security at
the database level, the query could still be edited. We'd prefer that they
don't edit the query.
 
Excel said:
I would
prefer for security reasons that they cannot edit the query, only refresh the
query.
Even if we establish Oracle security at
the database level, the query could still be edited.
Click to expand...

What about putting the SQL code in a stored procedure on the server
side? I suppose they could still change the calling command text e.g.
to call a different stored proc but a least they couldn't mess with the
query in question.

Jamie.

--
 
What is a stored procedure on the server side. I'm an accountant not a
programmer. Can you clarify?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query of External Data 2
Unprotect sheet to "Refresh All" Access queries 2
Wait statement in macro 1
Refresh pivot table on protected sheet 3
External data connection needs separate login for each query 1
Excel 2007 / MS Query - editing existing query to another sheet 0
Pivot tables - Editing the data source shared by multiple pivot ta 1
Counting multiple memberships 1

Back
Top