script for assigning access controls and cleanup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

%NAME% - 23 Feb 2007 21:16 GMT

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.

Reply to this Message

swami - 25 Feb 2007 05:10 GMT

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

swami.
---------------------

> I am admin a db2 instance for a class of over 500 students. I am
> wondering
[quoted text clipped - 9 lines]
> thanks in
> advances.

Reply to this Message

%NAME% - 28 Feb 2007 02:51 GMT

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

sorry i am new to stored procedure

> just write a stored procedure for truncating the tables having student
> details and run it.
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Reply to this Message