Thanks azdzn.
In Oracle, from toad for Oralce, if we select a table and see the Script, it shows complte table script along with the grants
But in SSMS, I can only see the create script but NOT the grants.
Is there a way in SSMS, we can see the grants along with table script.
In Toad:
CREATE TABLE ACCOUNT
(
ACCOUNT NUMBER NOT NULL,
ACCOUNT_NBR VARCHAR2(20 BYTE) NOT NULL)
GRANT DELETE, INSERT, SELECT, UPDATE ON ACCOUNT TO PUBLIC;
And also your script listing all the user's grants in a database. But I want to see for a particular user, what grants he has in a database.