dbTalk Databases Forums  

execute a command string

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss execute a command string in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mauro compagnoni
 
Posts: n/a

Default execute a command string - 10-25-2007 , 11:48 AM






hi,
i have a problem in executing a command. i want to grant
administrator rights to another user, but i have to select
it in a table.
this is my code:

declare @appo varchar (20)
select @appo=Login from Speedy.RemoteAccount where ...
exec ('grant dba to'||@appo)

but i have an error.
do you know which is the correct syntax?
thanks in advance
best regards
Mauro

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.