Advanced Query Ownership

[Bowman, Mark]

I have a number of Advanced Queries that I have created over the years.  I am passing my duties off to another individual.

Is there a way to transfer ownership of these to him in bulk, or should I make each one public?

 

Mark Bowman

Truckee Meadows Water Reclamation

City of Sparks

8500 Clean Water Way

Reno, NV 89502

 

[Charlie Larrabee]

I would say make each one public. It may generate more discussion.

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.
To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.
Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

*Breach of Confidentiality & Accidental Breach of Confidentiality*
The information contained in this transmission may contain privileged and confidential information, which is protected by federal and state privacy laws. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution, or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

[Currano, Joe]

I created an advanced query as a way to back up my advanced queries. After executing the query below, you can put them into an excel file, and he can paste the ones he wants into his own queries. The other option is to go to each query, export, and have the new user import them. Neither one is really a bulk export/import, unfortunately.

 

SELECT * from SAVEDQUERIES where OWNER like “User_01”

 

You can also select only certain fields such as QUERYNAME and QUERY, which may be cleaner if don’t need all the other stuff.

 

-Joe