Subject | Troubles with ROLE |
---|---|
Author | W O |
Post date | 2012-04-14T16:48:44Z |
Hello everybody
I have (or had) a role calle R_ADMIN, I don't know, because when I write:
DROP ROLE R_ADMIN
Appears the message:
"Statement failed, SQLSTATE = 42000"
"unsuccessful metadata update"
and if I write:
CREATE ROLE R_ADMIN
Appears the message:
"Statement failed, SQLSTATE = 28000"
"unsuccessful metadata update"
"-user name R_ADMIN could not be used for SQL role"
Which is the problem? Why I can not drop or create that role? Until some
days ago I had the R_ADMIN role and it was well.
Thanks in advance.
Walter.
[Non-text portions of this message have been removed]
I have (or had) a role calle R_ADMIN, I don't know, because when I write:
DROP ROLE R_ADMIN
Appears the message:
"Statement failed, SQLSTATE = 42000"
"unsuccessful metadata update"
and if I write:
CREATE ROLE R_ADMIN
Appears the message:
"Statement failed, SQLSTATE = 28000"
"unsuccessful metadata update"
"-user name R_ADMIN could not be used for SQL role"
Which is the problem? Why I can not drop or create that role? Until some
days ago I had the R_ADMIN role and it was well.
Thanks in advance.
Walter.
[Non-text portions of this message have been removed]