eliminating a role
From: Serge Taylor <st0u+_at_andrew.cmu.edu>
Date: Tue, 12 Apr 1994 11:35:51 -0400
Message-ID: <shefzLy00VBKM_BkoE_at_andrew.cmu.edu>
Date: Tue, 12 Apr 1994 11:35:51 -0400
Message-ID: <shefzLy00VBKM_BkoE_at_andrew.cmu.edu>
I mistakening created a "role" by
grant dba,resource to piglet
before I created the user piglet, so
naturally I can't create the user piglet.
How do I eliminate the role piglet from Oracle v.7
system so it doesn't remember piglet and stop me
from creating user piglet?
I tried revoke dba,resource from piglet;
but this doesn't seem to wipe out the role.
Thanks in advance,
Serge Taylor
Received on Tue Apr 12 1994 - 17:35:51 CEST