[
https://issues.apache.org/jira/browse/CASSANDRA-7607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14181412#comment-14181412
]
Robert Stupp commented on CASSANDRA-7607:
-----------------------------------------
You can find examples in the JUnit {{org.apache.cassandra.cql3.UFTest}}.
E.g.
{noformat}
CREATE FUNCTION sin ( input double ) RETURNS double LANGUAGE java AS 'return
Double.valueOf(Math.sin(input.doubleValue()));
CREATE OR REPLACE FUNCTION sin ( input double ) RETURNS double LANGUAGE java AS
'return Double.valueOf(Math.sin(input.doubleValue()));
DROP FUNCTION sin;
{noformat}
Please note, that permissions for UDFs are not yet fully implemented
(CASSANDRA-7557) and they will change to be more like types or tables
(CASSANDRA-7813).
> Test coverage for authorization in DDL & DML statements
> -------------------------------------------------------
>
> Key: CASSANDRA-7607
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7607
> Project: Cassandra
> Issue Type: Test
> Components: Tests
> Reporter: Robert Stupp
> Assignee: Rajanarayanan Thottuvaikkatumana
> Labels: lhf, unit-test
> Fix For: 2.0.12
>
>
> Similar to CASSANDRA-7604
> Check that the statements perform proper authorization (allow / reject):
> * {{CREATE KEYSPACE}}
> * {{ALTER KEYSPACE}}
> * {{DROP KEYSPACE}}
> * {{CREATE TABLE}}
> * {{ALTER TABLE}}
> * {{DROP TABLE}}
> * {{CREATE TYPE}}
> * {{ALTER TYPE}}
> * {{DROP TYPE}}
> * {{CREATE INDEX}}
> * {{DROP INDEX}}
> * {{CREATE TRIGGER}}
> * {{DROP TRIGGER}}
> * {{CREATE USER}}
> * {{ALTER USER}}
> * {{DROP USER}}
> * {{TRUNCATE}}
> * {{GRANT}}
> * {{REVOKE}}
> * {{SELECT}}
> * {{UPDATE}}
> * {{DELETE}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
