Andreas Grund wrote:
> 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.
Try it with
grant select ("Calls_E20") on "1_4_Calls_KNL" to "ROLLE"
For mor information have a look here
http://www.sapdb.org/7.4/htmhelp/48/f0dac7225811d3a97d00a0c9449261/frameset.htm
Best regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
