dynamic reporting

Hi Experts...
I want to create report on the fly, for given mdx query , I mean without
having a pre build report format, and I am using FoodMart 2000 sample
database.
pls give me some ideas.....
Thanks in Advance...If I understand what you mean correctly (and using RS) . . . . . I guess
you'd need to create the RDL file dynamically and have it executed
(I think) 8^)
- peteZ
"Sumudu Prasad" <sumudu@.logicalasia.com> wrote in message
news:uo%23XGEhmEHA.512@.TK2MSFTNGP10.phx.gbl...
> Hi Experts...
> I want to create report on the fly, for given mdx query , I mean without
> having a pre build report format, and I am using FoodMart 2000 sample
> database.
> pls give me some ideas.....
> Thanks in Advance...
>
>

Dynamic Granting of Insert Permissions?

I need to restrict insert permissions on a single table to a pre defined time window each day.

One way would be to craete a new user in NT and restrict login to the time window, and then only grant insert permissions on the table to this user.

better, though, would be to achieve this at DB level. Is this possible?Why would you ever need to do this at the DB level?

You might be able to set up a trigger to remove the inserted row after it is added if the time is in a range.

Better would be to have your application logic restrict access to the insert statement between certain times.