SEO

#1 (**permalink**) 02-27-2008, 11:49 AM

I am admin a db2 instance for a class of over 500 students. I am
wondering
if there is some scripts already for assigning basic authorization to
the a
list of studentIds and bookkeep their objects. Later after the
semester, i could
run the script to purge everything created by the students while not
touching
anything else.

if you know such resources, would you please leave me a line? many
thanks in
advances.

#2 (**permalink**) 02-27-2008, 11:49 AM

just write a stored procedure for truncating the tables having student
details and run it.

swami.
---------------------
On Feb 24, 2:16 am, "%NAME%" <hbccan...@gmail.com> wrote:
> I am admin a db2 instance for a class of over 500 students. I am
> wondering
> if there is some scripts already for assigning basic authorization to
> the a
> list of studentIds and bookkeep their objects. Later after the
> semester, i could
> run the script to purge everything created by the students while not
> touching
> anything else.
>
> if you know such resources, would you please leave me a line? many
> thanks in
> advances.

#3 (**permalink**) 02-27-2008, 11:50 AM

do you know any existing stored procedures that do that kind of
things?

sorry i am new to stored procedure

On Feb 25, 12:10 am, "swami" <sivaswamim...@gmail.com> wrote:
> just write a stored procedure for truncating the tables having student
> details and run it.
>
> swami.
> ---------------------
> On Feb 24, 2:16 am, "%NAME%" <hbccan...@gmail.com> wrote:
>
>
>
> > I am admin a db2 instance for a class of over 500 students. I am
> > wondering
> > if there is some scripts already for assigning basic authorization to
> > the a
> > list of studentIds and bookkeep their objects. Later after the
> > semester, i could
> > run the script to purge everything created by the students while not
> > touching
> > anything else.
>
> > if you know such resources, would you please leave me a line? many
> > thanks in
> > advances.- Hide quoted text -
>
> - Show quoted text -

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

script for assigning access controls and cleanup