[jira] [Comment Edited] (CASSANDRA-7212) Allow to switch user within CQLSH session

["Sachin Janani (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-7212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14490904#comment-14490904 ] 

Sachin Janani edited comment on CASSANDRA-7212 at 4/11/15 10:24 AM:
--------------------------------------------------------------------

Hi [~carlyeks] ,
Uploaded the updated patch which prompt user if password is not specified in command.
Also if server grammar is not changed then I get an error.I think the command is also validated using the server grammar as well.Following is the error the i get:
{quote}
  sachin@cqlsh:demo> use demo sachin;
  SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:15 mismatched input ';' expecting set null (use demo sachin[;])">
{quote}


was (Author: sachinjanani):
Hi [~carlyeks] ,
Uploaded the updated patch which prompt user if password is not specified in command.
Also if server grammar is not change the I get an error.I think the command is also validated using the server grammar as well.Following is the error the i get:
{quote}
  sachin@cqlsh:demo> use demo sachin;
  SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:15 mismatched input ';' expecting set null (use demo sachin[;])">
{quote}

> Allow to switch user within CQLSH session
> -----------------------------------------
>
>                 Key: CASSANDRA-7212
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7212
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: API
>         Environment: [cqlsh 4.1.1 | Cassandra 2.0.7.31 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
>            Reporter: Jose Martinez Poblete
>              Labels: cqlsh
>         Attachments: 7212_1.patch, 7212_v2.patch
>
>
> Once a user is logged into CQLSH, it is not possible to switch to another user  without exiting and relaunch
> This is a feature offered in postgres and probably other databases:
> http://secure.encivasolutions.com/knowledgebase.php?action=displayarticle&id=1126 
> Perhaps this could be implemented on CQLSH as part of the "USE" directive:
> USE <Keyspace> [USER] [password] 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)