gary1 (1/13/2012)

---

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.