[dba-SQLServer]Permission to My Own Table

Nicholson, Karen knicholson at gpsx.net
Thu Jun 26 14:00:34 CDT 2003


I tried that, but this is a database used company-wide and it will not
perform the function as others have it open.  I only want to affect this
table, not the whole database.

> -----Original Message-----
> From:	Djabarov, Robert [SMTP:Robert.Djabarov at usaa.com]
> Sent:	Thursday, June 26, 2003 1:55 PM
> To:	dba-sqlserver at databaseadvisors.com
> Subject:	RE: [dba-SQLServer]Permission to My Own Table
> 
> sp_dboption your_db_name, 'select into', true
> 
> Robert Djabarov
> Senior SQL Server DBA
> USAA IT/DBMS
> ? (210) 913-3148 - phone
> ? (210) 753-3148 - pager
> 
> 
>  -----Original Message-----
> From: 	Nicholson, Karen [mailto:knicholson at gpsx.net] 
> Sent:	Thursday, June 26, 2003 1:25 PM
> To:	dba-SQLServer at databaseadvisors.com
> Subject:	[dba-SQLServer]Permission to My Own Table
> 
> Dumb question. I created a new table in an SQL application.  I can not use
> the table, it is telling:
> 
> Server: Msg 268, Level 16, State 3, Procedure gps_proactive_XALPRO, Line
> 289
> Cannot run SELECT INTO in this database. The database owner must run
> sp_dboption to enable this option.
> 
> I have set all the permissions in the table for the whole world up update,
> select, etc.  What the?  I am sure this is something really easy.  Thanks.
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com


More information about the dba-SQLServer mailing list