What is big data?

#11

Paul Mason wrote:

Quote:

GRANT NOACCESS ON DATABASE mydb TO PUBLIC

What makes me feel more of a fool is that I actually knew that.

More coffee...

--
Roy

UK Actian User Association Conference 2012 will be on Tuesday June 11. 2013.
The latest information is available from www.uk-iua.org.uk.

#12

Thanks guys.

Another time saver to put in my little black (actually blue) book.

Much appreciated.

Regards,
Andy.

On 10/07/2012 6:14 PM, Paul Mason wrote:

Quote:

GRANT NOACCESS ON DATABASE mydb TO PUBLIC

HTH

Paul

*From:*info-ingres-bounces (AT) kettleriverconsulting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] *On Behalf Of *Andy
*Sent:* 10 July 2012 03:42
*To:* info-ingres (AT) kettleriverconsulting (DOT) com
*Subject:* [Info-Ingres] Public to private database

Hi All,

Can someone tell me how to change a database access from public to
private using an SQL command.

I have the following to add roles to my installation, etc. Just not sure
about database access...

sql -u'$ingres' iidbdb <<SQLEND
create role myrole with password = 'myrolepw'; \p\g
grant myrole to public; \p\g
SQLEND

Any help is greatly appreciated.

Regards,
Andy.

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What is big data?

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] Public to private database - 07-10-2012 , 04:33 AM

Re: [Info-Ingres] Public to private database - 07-10-2012 , 11:14 AM