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