Hi good afternoon to every one..
Now I am accessing remote database server in postgresql..
but I can see all tables and functions in remote database server but I can
delete,update,alter and drop tables in remote database server from my local
machine.. to avoid these things wt I have to
create a user with limited permmission and give the same to the remote users.May be that will solve your problem. REVOKE INSERT,UPDATE,DELETE ON welcome from PUBLIC;
On 7/4/06, Penchalaiah P. <[EMAIL PROTECTED]> wrote:
Hi good afternoon to every one..
Now I am accessing remote da
I have 290 tables .. to these tables one
schema is there .. that name is public….so I don’t know how to create
permission to these tables.. either I have to give permissions to individual
table.. or I have to give permissions to schema or schema name… if I give permission
to schema it has t
I am not an expert in postgres, may this work for you.REVOKE INSERT,UPDATE,DELETE ON ALL from PUBLIC;it will take the INSERT,UPDATE,DELETE permmission from all users for all objects in the database.
If you want to give permission for a specific user on all objects GRANT ALL on ALL to ;
Please mak
> I am not an expert in postgres, may this work for you.
> REVOKE INSERT,UPDATE,DELETE ON ALL from PUBLIC;
> it will take the INSERT,UPDATE,DELETE permmission from all users for all
> objects in the database.
> If you want to give permission for a specific user on all objects
> GRANT ALL on ALL to
MJ Santhosh <[EMAIL PROTECTED]> schrieb:
> I am not an expert in postgres, may this work for you.
>
> REVOKE INSERT,UPDATE,DELETE ON ALL from PUBLIC;
IIRC, you cant REVOKE ... ON ALL, you need a table-name instead ALL.
But, you can create a script for all tables:
http://people.planetpostgresql
You can start by creating 3 views for your 3 categories:CREATE OR REPLACE VIEW cat_a ( account_id, sales_cat_a) ASSELECT
account_id,
sum(sale_price) as sales_cat_aFROM sales -- Assuming sales is the table with the dataWHERE product_id in ('prod1', 'prod2')GROUP BY account_idThen do
How can I get all attributes that is not null
+ don’t have defaults + is not PKs??? I know I have to use system
catalog, but I have some Pks that is multicolumn!
Any help??
Rodrigo Sakai
Administrador de Banco de Dados
É(11) 3750-7075
* [EMAIL PROTECTED]
