Hu Mailinglist,
i�ve got a little problem with the grant-statement. I work with sapdb 7.4.3.25 under
WinNT. I�ve create a table like:
CREATE TABLE "ROOT"."1_4_Calls_KNL"
(
"Tag" Timestamp,
"KC_ID" Integer,
"Hotline_ID" Integer,
"Belegung" Float (16),
"Calls" Float (16),
"Calls_E20" Float (16),
"Fore" Float (16),
FOREIGN KEY "Hotline" ("Hotline_ID") REFERENCES "ROOT"."0_6_Hotline" ("ID")
ON DELETE RESTRICT
)
After that i create a new databaseuser with:
create user "HANS" password "KLAUS" DBA
and a new role:
create role "ROLLE"
Now i tried to grant the select-privileg on the "Calls_E20" column to the role:
grant select on "1_4_Calls_KNL"."Calls_E20" to "ROLLE"
but i get the error unknown user name. This is clear, because the user "1_4_Calls_KNL"
doesn�t exist. But if this statement isn�t correct, what do i have to do if i want to
grant the privileg? In the sapdb library stands:"Allows the identified user to select
rows in the specified table. If column names are specified, the rows may only be
selected in the columns identified by these names. The current user must be authorized
to grant the SELECT privilege.", so it�s possible, but how?? I�m connected to the
database as sysdba.
Greeting and thanks in advance,
Andreas
________________________________________________________________
Mit der Grupppen-SMS von WEB.DE FreeMail k�nnen Sie eine SMS an alle
Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
