On Jan 18, 2012, at 12:25 PM, salah jubeh wrote:
> Hello,
>
> Thanks for the info, I have already solved this by writing the following
> function. Also, i think it is better than changing the schema tables directly
>
> Regards
>
It doesn't look like the procedure handles grant options (W
|| privilegeType ||' ON TABLE '
|| quote_ident ($2) ||' TO '|| roleName || E';\n' ;
END LOOP;
END LOOP;
--Execute ALL
EXECUTE grantSQL;
END
$$ LANGUAGE 'plpgsql' ;
From:
On Jan 18, 2012, at 8:48 AM, salah jubeh wrote:
> Hello,
>
> I have create a table from another table such as
>
> CREATE TABLE tmp_XXX AS SELECT * FROM XXX;
>
>
> The tmp_XXX tables has no permissions assigned to it and I want to assign
> it with the same owner and access privileges o
On Thu, Mar 31, 2005 at 08:57:17PM -0500, Joseph Shraibman wrote:
>
> Is there a function I can call to see if the current user has
> permissions on a certain table?
See "System Information Functions" (or "Miscellaneous Functions")
in the "Functions and Operators" chapter of the documentation.
He
Is there a function I can call to see if the current user has
permissions on a certain table?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
