var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is there a way of granting a privilege across all objects (tables, functions, triggers, views, sequences, etc.) within a database from a single GRANT statment, or must I issue a GRANT on each table (view, sequence, etc.)?
I think that you must grant every tables but there are better ways than writing everything.
If you have many users to grant you can create groups and apply permisions to the groups.
To avoid writing a lot, just make a query to retrieve all the tables. So you can make a select like this:
select 'grant select, insert, update, delete, rule on ' + systable.nobre + ' to ' + usuario
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors