You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "Lu, Boying" <Bo...@emc.com> on 2014/07/17 12:30:32 UTC

How to prevent writing to a Keyspace?

Hi, All,

I need to make a Cassandra keyspace to be read-only.
Does anyone know how to do that?

Thanks

Boying


RE: How to prevent writing to a Keyspace?

Posted by "Lu, Boying" <Bo...@emc.com>.
I see.

Thanks a lot ☺

From: Vivek Mishra [mailto:mishra.vivs@gmail.com]
Sent: 2014年7月21日 14:16
To: user@cassandra.apache.org
Subject: Re: How to prevent writing to a Keyspace?

Create different user and assign role and privileges. Create a user like guest and grant select only to that user. That way user cannot modify data in specific keyspace or column family.

http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/grant_r.html

-Vivek

On Mon, Jul 21, 2014 at 7:57 AM, Lu, Boying <Bo...@emc.com>> wrote:
Thanks a lot ☺

But I think authorization and authentication do little help here.

Once we allow an user to read the keyspace, how can we prevent him from writing DB
without Cassandra’s help?

Is there any way to support ‘read-only’ some keyspace in Cassandra ? e.g. set some specific strategy?

Boying

From: Vivek Mishra [mailto:mishra.vivs@gmail.com<ma...@gmail.com>]
Sent: 2014年7月17日 18:35
To: user@cassandra.apache.org<ma...@cassandra.apache.org>
Subject: Re: How to prevent writing to a Keyspace?

Think about managing it via authorization and authentication support

On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying <Bo...@emc.com>> wrote:
Hi, All,

I need to make a Cassandra keyspace to be read-only.
Does anyone know how to do that?

Thanks

Boying




Re: How to prevent writing to a Keyspace?

Posted by Vivek Mishra <mi...@gmail.com>.
Create different user and assign role and privileges. Create a user like
guest and grant select only to that user. That way user cannot modify data
in specific keyspace or column family.

http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/grant_r.html

-Vivek


On Mon, Jul 21, 2014 at 7:57 AM, Lu, Boying <Bo...@emc.com> wrote:

> Thanks a lot J
>
>
>
> But I think authorization and authentication do little help here.
>
>
>
> Once we allow an user to read the keyspace, how can we prevent him from
> writing DB
>
> without Cassandra’s help?
>
>
>
> Is there any way to support ‘read-only’ some keyspace in Cassandra ? e.g.
> set some specific strategy?
>
>
>
> Boying
>
>
>
> *From:* Vivek Mishra [mailto:mishra.vivs@gmail.com]
> *Sent:* 2014年7月17日 18:35
> *To:* user@cassandra.apache.org
> *Subject:* Re: How to prevent writing to a Keyspace?
>
>
>
> Think about managing it via authorization and authentication support
>
>
>
> On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying <Bo...@emc.com> wrote:
>
> Hi, All,
>
>
>
> I need to make a Cassandra keyspace to be read-only.
>
> Does anyone know how to do that?
>
>
>
> Thanks
>
>
>
> Boying
>
>
>
>
>

RE: How to prevent writing to a Keyspace?

Posted by "Lu, Boying" <Bo...@emc.com>.
Thanks a lot ☺

But I think authorization and authentication do little help here.

Once we allow an user to read the keyspace, how can we prevent him from writing DB
without Cassandra’s help?

Is there any way to support ‘read-only’ some keyspace in Cassandra ? e.g. set some specific strategy?

Boying

From: Vivek Mishra [mailto:mishra.vivs@gmail.com]
Sent: 2014年7月17日 18:35
To: user@cassandra.apache.org
Subject: Re: How to prevent writing to a Keyspace?

Think about managing it via authorization and authentication support

On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying <Bo...@emc.com>> wrote:
Hi, All,

I need to make a Cassandra keyspace to be read-only.
Does anyone know how to do that?

Thanks

Boying



Re: How to prevent writing to a Keyspace?

Posted by Vivek Mishra <mi...@gmail.com>.
Think about managing it via authorization and authentication support


On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying <Bo...@emc.com> wrote:

> Hi, All,
>
>
>
> I need to make a Cassandra keyspace to be read-only.
>
> Does anyone know how to do that?
>
>
>
> Thanks
>
>
>
> Boying
>
>
>