Granting privileges to a role
I wanted to create a role and grant all thsoe privileges to that role and then add the user to that role. But since I am using WITH GRANT OPTION I can't do that since it is not possiblt to grant priveleges to a role using that option. My questiong is granting the object privileges to the user using WITH GRANT option directly is my only option?