Drop user if exists

Follow

Walter Weinmann

• June 02, 2021 16:48

How can I check if a user already exists - since DROP USER IF EXISTS is not possible ?

0

• 

  Pey Silvester

  • June 02, 2021 18:35

  Hi Walter!

  Thank you for using OmniSci and providing your feedback.

  At this time, your request would be a manual two step process. If you have admin privileges, you could use the /u command in omnisql which will retrieve the list of users. You can then manually inspect if the user exists and then use the DROP USER command.

  I have added a DROP USER IF EXISTS feature request to our backlog.

  0

  Comment actions Permalink
• 

  Walter Weinmann

  • June 02, 2021 19:14

  Thank you very much for the quick reply.

  I'm accessing the database via JDBC - so I would need a SQL query to determine the existence of a user account - any chance ?

  0

  Comment actions Permalink
• 

  Pey Silvester

  • June 02, 2021 19:19

  Not at this time. We already have a request to allow this type of queries for system information. I will add your vote to that request.

  0

  Comment actions Permalink
• 

  Walter Weinmann

  • June 03, 2021 06:30

  I would prefer the DROP USER IF EXISTS solution - at the moment I can work around the problem - but it would be nice if there was a solution in the foreseeable future. :grinning:

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • June 03, 2021 08:31

  It's likely that in the future, both of them will materialize on omnisci database ;)

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • December 24, 2021 11:49

  Hi @walter ,

  Recently we added the DROP USER IF EXIST that you needed for full implementation of your tool.

  You can refer to syntax in the docs. https://docs-new.omnisci.com/sql/data-definition-ddl/users-and-databases#drop-user*

  Regards, Candido.

  0

  Comment actions Permalink
• 

  Walter Weinmann

  • December 28, 2021 06:05

  Hi @candido.dessanti

  Thanks for the tip - this works fine for me now.

  But unfortunately, I still have the problem with the 2nd database connection open: https://github.com/omnisci/omniscidb/issues/668

  Thanks and best regards

  Walter

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • December 29, 2021 13:35

  I will take a look to it

  0

  Comment actions Permalink

Please sign in to leave a comment.