schaapie
Member
I would like to reset the sql-92-rights on a database.
I would like to start with the command:
And after that grant to specified users.
But the * is not recognized. "from public" still leaves a user granted with rights, I think it's the creator or owner or something.
Is there a way to do this. Perhaps there is a way to find out which users have any rights at all at the moment so I can include this in a generator for the sql-statement?
Thanks
I would like to start with the command:
Code:
revoke all on pub.ACCOUNT from *;But the * is not recognized. "from public" still leaves a user granted with rights, I think it's the creator or owner or something.
Is there a way to do this. Perhaps there is a way to find out which users have any rights at all at the moment so I can include this in a generator for the sql-statement?
Thanks