Create/ change authorizations for queries

Question: Hi,
I work for a company with 3-4 divisions.
For Co-PA cube we decided to give change authorizations for queries to one person in each division.

My question is how can I avoid from someone to change queries belonging to other divisions.
Regarding data...each one sees only his own data.

Thanks in advance,
Ada

Answer:
I did it once defining a naming convention for each division, and then creating authorizations for those. For example, people from the division 1 only has authorizations to save, change, delte, and run queries which technical name begins with "DIV1_".
Would that make it?
Copyright ?2007 - 2008 www.jt77.com