Sybase Database - Revoke user from using tempdb 12.5.3 how to

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Revoke user from using tempdb 12.5.3 how to

Maria

2006-04-04, 8:23 pm

Hello

I have created a multiple tempdb in ASE 12.5.3. solaris 5.8 but I would
like to revoke from "normal" tempdb usage from a user.
Lets say I have created a new tempdb called tempdbtest and JohnDoe
user should be only able to use the tempdbtest, I have binded the user
to use this db, but if I say create table in tempdb or use tempdb then
create table the John Doe user can create a table.

How can I revoke John Doe all priviliges from using tempdb? I have
tried many different things and so far no luck.
Can someone please help?

Thank you very much
Maria

Sponsored Links