Reporting on Command Restrictions in Supervisor

[system]

Hi Fellow Bobers,

I am currently in the process of ‘service packing’ our current BO setup from Business Objects 5.1.2 and Webi running against SQL Sever2K repository to BO 5.1.8 and WebI 2.7.4

The current supervisor setup was setup for a pilot 2 years ago and has proved inadequate for our expanding user base.

[b]I have a question relating to extracting info regarding users Command Restrictions in Supervisor.

My set up is Business Objects 5.1.2 running against SQL Sever2K repository.[/b]

I would like to run a report or SQL which will list the current Command Restriction settings for every Group and User within the repository… is this possible?

Anyhelp would be greatly appreciated as I cannot find a method using supervisor itself.

Many Thanks in Advance

Memnoch the

---

Memnoch (BOB member since 2004-06-09)

[system]

Please, try a search on BOB, suggested keywords: Reporting Command Restrictions Supervisor

Or start with this post.

---

Andreas (BOB member since 2002-06-20)

[system]

@Memnoch

Hi Fellow Bobers,

I am currently in the process of ‘service packing’ our current BO setup from Business Objects 5.1.2 and Webi running against SQL Sever2K repository to BO 5.1.8 and WebI 2.7.4

The current supervisor setup was setup for a pilot 2 years ago and has proved inadequate for our expanding user base.

[b]I have a question relating to extracting info regarding users Command Restrictions in Supervisor.

My set up is Business Objects 5.1.2 running against SQL Sever2K repository.[/b]

I’m getting ready to post the stuff to do this in the download area. If you are willing to test my instructions, use my zip file, unzip and create the views and table required, and test the process, I’ll send it to you so you can be my guinea pig. If you’re willing, post back and I’ll send you an email.
I would like to run a report or SQL which will list the current Command Restriction settings for every Group and User within the repository… is this possible?

Anyhelp would be greatly appreciated as I cannot find a method using supervisor itself.

Many Thanks in Advance

Memnoch the

I’m getting ready to post the stuff to do this in the download area. If you are willing to test my instructions, use my zip file, unzip and create the views and table required, and test the process, I’ll send it to you so you can be my guinea pig. If you’re willing, post back and I’ll send you an email.

Are you Oracle?

---

Cindy Clayton (BOB member since 2002-06-11)

[system]

Thankyou very much for your reply !!

And if I can I will happily be your guinea pig

My repository is running on MS SQL Server2K this will nodoubt cause a problem??

If you want to strike up a private conversation concerning testing check your email where i have sent from the address of where I work.

Cheers

Memnocgh the

---

Memnoch (BOB member since 2004-06-09)

[system]

@Memnoch

Thankyou very much for your reply !!

And if I can I will happily be your guinea pig

My repository is running on MS SQL Server2K this will nodoubt cause a problem??

If you want to strike up a private conversation concerning testing check your email where i have sent from the address of where I work.

Cheers

Memnocgh the

I’m really looking for an Oracle guinea pig but I’ll keep you in mind when I finish the SQLServer version. I’ll watch my email for your address. Thanks!!

---

Cindy Clayton (BOB member since 2002-06-11)

[system]

Cindy’s file is available here (link removed). Official posting to BOB’s Downloads will probably happen tomorrow.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)