General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
Likes (1)
Naomi Nosonovsky
Hi Richard,
I can assure you it isn't the ODBC driver. I create both SQL Databases and SQL tables in the SQL Server from metadata, as part of our build process, which is used quite regularly. As Sergey indicates, it's a credentials and role assigned to those credentials issue.
Hank
>Hi to All
>
>Thanks to all who have provided assistance to my problems in the past.
>
>I have a situation where I need to "SELECT * INTO new_table FROM existing_table"
>
>No matter how I have tried to GRANT 'CREATE TABLE' rights to the users and or roles, I get the following error.
>"Create table permission denied in database mydatabase"
>
>Is the problem systemic with respect to my using ODBC 32 as the pass-through middle-ware or is it a fixable problem in my VFP calling command or in SQLMS?
>
>I have also used it in Win XP standalone, Win Server 2008 and with SQL Server 2005 and SQL Server 2008 R2.
>
>Any help or ideas are welcome.
>Thanks again very much
>Rich Balluff
>RLB Associates
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only