Ohh, sorry! Got it! Of course I have to use the GRANT statement.
kind regards
Frank Schimmelpfennig
PHILIPS Semiconductors Hamburg
ATO-Hamburg IT&DataSupport
Tel.: +49 40 5613 -1835, Fax: -3020
"Zabach, Elke"
<elke.zabach@sap To: Frank
Schimmelpfennig/HBG/SC/PHILIPS@EMEA1
.com> [EMAIL PROTECTED]
cc:
15.05.2002 16:16 Subject: RE: Modify an existing
DB Role
Classification:
[EMAIL PROTECTED] wrote:
> is there any possibility to modify an existing db role? I
> wish to add additional priviledges to an existing role but
> did not find any hint like 'ALTER ROLE' or simular.
Mhm, do I understand correctly that you have created a role
and this role does not have any privileges by now?
Or how did you prepare your existing role with those privileges in them
(you spoke of ADDITIONAL privileges)?
Usually privileges are handled with GRANT and REVOKE.
And this is true for privileges granted to roles, too.
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
