Hello All,

How to drop a user which have a database and in that database some tables are also there.
Is there a way to directly drop that user,so that we dont need to drop database,tables seperately.

Thanks
Rachel


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

That sounds like a database specific question as opposed to a hibernate question. Unless you want to do it at run time via hibernate... I really don't think you can do something like that. And in a production system it's probably not really a good idea to.
What database are you using? With SQL you can pretty much do anything regarding your DB... so I'd look into that.

Hi All,
I'm using PostgresSql as my database and would like to remove a user at runtime so that i should not delete database or the tables that user is having.

Regards
Rachel