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.
Please try
grant select("Calls_E20") on "1_4_Calls_KNL" to "ROLLE"
Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
