Hello everyone,
I would want to implement an SQL query where I would be able to suppress all
information from a registered user. I am currenlty able to suppress
everything except the user role. The name of the role is present in a table
and so, I would want to perform something like this :
DROP ROLE (SELECT ...)
but this is not considered as valid, as DROP ROLE is expecting a name and
not a text field. So, I tried the following, but with no success :
DROP ROLE CAST((SELECT...) AS name)
So, does someone knows how to handle this problem ?
Regards,
Brice