Permission problems user can't create a table

Hi there,

I'm new to SQL 2005 and am having what is probably an easy problem.

I have created a user called testuser in a database called testdb.
The login has access to the testdb database and has a default schema
of dbo.

I then allowed testuser the ability to create tables in the testdb
database. However when i try to create a table in the database as
that user it comes up with a persmissions error

'the specified schema name dbo either does not exist or you do not
have permissions to use it'

Do I need to set some further permissons to allow this user to create
tables, is it not enough to give them the create table permisson on
the database ?

Any help would be much appricated.

Thanks
Fran

.

Relevant Pages

  • Re: [newbie] CDatabase problem
    ... Enclose TESTDB and TestTable in single quotes, ... The next step is to create a specific database on this server (if not ... already existant). ... What is the correct code to do so? ...
    (microsoft.public.vc.mfc)
  • Re: [newbie] CDatabase problem
    ... In addition to what Peter has recommended, and in response to your question ... Enclose TESTDB and TestTable in single quotes, ... The next step is to create a specific database on this server (if not ... What is the correct code to do so? ...
    (microsoft.public.vc.mfc)
  • Re: Full Text Search Performance
    ... system that is 50 times slower for the simplest query that does not have much ... The drive letter that is used by the database is E, ... I have read something about configuring SQL to use a fixed memory on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Restore database
    ... Tibor Karaszi, SQL Server MVP ... I did a backup for application database: testdb ...
    (microsoft.public.sqlserver.setup)
  • Re: Restore database
    ... No need to create a database before you restore it. ... I did a backup for application database: testdb ...
    (microsoft.public.sqlserver.setup)