Grant permissions on table

[tprohas]

Can anyone tell me how to grant permissions on a SQL Server table in EA. I would think this should be a stereotype for an operation but its not. Everytime I recreate my database using EA I have to manually create all the permissions on the tables using Enterprise Manager. Please tell me there is an easier way to do this.

Regards,

Aaron

[folded_book]

Aaron,

As far as I am aware you can't create permissions on tables within EA - I could be wrong but I've never found the option to do it. Anyway, the best thing to do is to write yourself a separate script file which assigns all the permissions to the tables and run this in SQL Query Analyzer whenever you recreate your database.

Regards

Gary

[tprohas]

Thank you for the reply,
I have now done what you suggested. I really think this is an option that should be added to the EA database options.

Regards,

Aaron