Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 14
Newest
 Curious
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 66 votes cast
Feb
8
comment Trouble killing sessions then immediately dropping users in Oracle 11g XE
This works! Thanks, it is what I was looking for. Although, one thing still baffles me - why does it take SO LONG for the session to drop? I don't have any huge transactions pending, there is nothing at all happening, and yet it still takes upwards of 20-30 seconds before it finally dies and I can perform the drop. Ideas? If there is some system-wide setting I can adjust to fix this, that would be great too.
Feb
8
comment Trouble killing sessions then immediately dropping users in Oracle 11g XE
Thanks for your advice, but I'm still getting the error. Please see updated answer.
Feb
8
revised Trouble killing sessions then immediately dropping users in Oracle 11g XE
added 804 characters in body
Feb
8
awarded  Editor
Feb
8
revised Trouble killing sessions then immediately dropping users in Oracle 11g XE
deleted 6 characters in body
Feb
8
asked Trouble killing sessions then immediately dropping users in Oracle 11g XE
Dec
16
comment how to restore database from other server - sql
@Verbeia or possibly on DBA
Dec
16
comment how to restore database from other server - sql
What database software? SQL Server, MySQL, Oracle, PG, etc....?
Dec
13
awarded  Supporter
Dec
13
awarded  Scholar
Dec
13
comment What privileges do I have to grant to allow a user to select from information_schema.table_privileges?
I was able to change my code to use the sys views, and it works well. Thanks for your help.
Dec
13
accepted What privileges do I have to grant to allow a user to select from information_schema.table_privileges?
Dec
13
comment What privileges do I have to grant to allow a user to select from information_schema.table_privileges?
I don't understand - are you saying the user must be specifically granted permission to the "information_schema.table_privileges" view?
Dec
13
asked What privileges do I have to grant to allow a user to select from information_schema.table_privileges?
Dec
13
awarded  Autobiographer