create table permissions

[Bygbobbo]

Hi all,

We are finally implementing permissions on our MS SQL 2000 (sp2) server.

I have an issue with something though. When I create a table from the enterprize manager the table is created as DBO but when I open a query analyzer and create the same table it is created with the user Account.

e.g.
(1) dbo.test1
(2) [domain1\bygs].test2

My current permissions are set to db_owner.


Thanks in advance,
Bygs

 

[Bygbobbo]

bump

 

[tlbroadbent]

Are you using the same login for Enterprise Manager and Query Analyzer? When you create the object in Query Anlayzer, you must use the object owner in the Create statement.

Create Table dbo.NewTable (...) If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Bygbobbo]

I open enterprise manager which uses windows authentification. From there if I create a new table using enterprise manager it creates the table as dbo.table_name.

If open query analyzer from enterprise manager and create a table it then uses the appropriate permissions [domain1\bygs].table_name

very wierd