Friday, March 23, 2012

grant create_table permission?

Greetings,
So I am just starting out with DBA duties. I have created
a few new accounts. I checked the list of roles, but I
cannot find anywhere how you grant create_table
permissions to a login ID. I looked at all the
permissions/properties, but I just don't know how this is
done. May I request if someone could explain how this is
done?
Thanks,
RonYou need to do this through T-SQL:
GRANT CREATE TABLE TO user
"Ron" wrote:

> Greetings,
> So I am just starting out with DBA duties. I have created
> a few new accounts. I checked the list of roles, but I
> cannot find anywhere how you grant create_table
> permissions to a login ID. I looked at all the
> permissions/properties, but I just don't know how this is
> done. May I request if someone could explain how this is
> done?
> Thanks,
> Ron
>

No comments:

Post a Comment