Re: create table permission denied
- From: laimis <lsimutis@xxxxxxxxxxxxxxxx>
- Date: Fri, 20 Jan 2006 12:42:15 -0600
got it ... database role 'public' had DENY on creating tables. So even if my test login had GRANT, the DENY on public denied for test as well because test is public and db_owner.
laimis wrote:
Hello,
I hope this is something simple to fix, but so far I had no luck...
Situation:
I created sql login, let's say 'test' and allowed access to database db1. Actually, I made the account as the db_owner of db1. The test account was not added to any of the server roles. Now, everything is working fine until I try to create table or view or proc, etc. in the db1 while logged in as the test user.
When creating table I get that CREATE TABLE permission denied in database 'db1'. I tried executing GRANT CREATE TABLE after logging on as sysadmin to that test account. That didn't help. IS there some DENY somewhere that I don't see? How can I check what is preventing me from creating table using that account?
Any comments?
Thanks
.
- References:
- create table permission denied
- From: laimis
- create table permission denied
- Prev by Date: Setting up and securing SQL Express in a (potentially) hostile environment
- Next by Date: Re: MSDE login problem - Windows
- Previous by thread: create table permission denied
- Next by thread: Setting up and securing SQL Express in a (potentially) hostile environment
- Index(es):
Relevant Pages
|
|
