RE:Grant select privileg on a single column to a new user

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