August 8, 2008 at 2:55 pm
Hello,
I have created a database role and for the role I have given "create table" permission in the database.
A user who is a memeber of that database role still cannot create table .. It says "CREATE TABLE permission denied in database..."
Unless I issue this statement,
grant create table to USER1
the USER1 cannot create table..
When the USER1 is a memeber of the database role "ROLE1" which has "create table" permission, why the USER1 is not inheriting from the ROLE1??
PLEASE HELP!
Thanks.
August 8, 2008 at 3:03 pm
It's possible the user account had a priorly-issued deny on that right. That would override the group right (if I remember correctly).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 8, 2008 at 3:22 pm
No.. I even tried with a NEW login and it does the same.. Please help!!
August 8, 2008 at 3:33 pm
Review the public role, maybe somebody set explicit deny rights on that role.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
August 8, 2008 at 3:58 pm
Is there a TSQL way to find out why a permission is denied??..
For example, how to find out why the user is deined the "CREATE TABLE" permission.. the source that prevents it..
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply