473,545 Members | 1,779 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

failed to update my dbase!

I'm facing trouble to update the data in the SQLServer
2000. When ever I try to update it I get a message that goes like this:

SELECT permission denied on object 'staff', database 'dbname',
owner'owner name'.
UPDATE permission denied on object 'staff', database 'dbname', owner
'owner name'.
What Problem do you think this can be . I've tryed to look for the
restriction but there are non.
Thank you..

Dec 1 '06 #1
1 1058
Well, the account you are running under does not have the necessary
permissions for the table you want to update and select from.

Use enterprise manager to set the security for the table and assign
the necessary permissions

On 1 Dec 2006 04:47:18 -0800, "rcoco" <nc******@yahoo .cawrote:
>I'm facing trouble to update the data in the SQLServer
2000. When ever I try to update it I get a message that goes like this:

SELECT permission denied on object 'staff', database 'dbname',
owner'owner name'.
UPDATE permission denied on object 'staff', database 'dbname', owner
'owner name'.
What Problem do you think this can be . I've tryed to look for the
restriction but there are non.
Thank you..
--

Bits.Bytes.
http://bytes.thinkersroom.com
Dec 1 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
5518
by: Ivan | last post by:
Hi, SQL Server 2000 SP3 Windos 2000 Server SP4 I have a DTS package that imports data from a dBase IV databse with files located in two folders (dBF1 and dBF2). I use a transform data task to transform the data. They were running properly, but last week we installed W2K SP4, and
3
5478
by: Frank | last post by:
Hi, the problem I have is that an older dos program is using dbase 3 or 4 database files and I wish to add a little utility that scanns this database, and if specific record has a certain entry (flag) i wish to extract all of the records for this entry change the flag in the dbase file and write it into a new mdb database. The second part is...
0
1172
by: Salvador - From Galicia(Spain) | last post by:
I want read some data from dbf file stored in a server. The webservice are going developed in the same server. Web service path \\server\webservices\service1\service.asmx Dbf files path \\server\d\dbf_files\files\ 'd' not is a folder, 'd' is a secondary harddisk Connection String Driver={Microsoft dBASE Driver (*.dbf)}; FIL=dBase 3.0;Data
2
2310
by: Songyang | last post by:
I'm new to this group. In my company in Japan, we have been using dbase for almost 20 years, and we are now switching to foxpro. Dose anybody here has experience in converting dbase programs from Dbase to Foxpro ones? It seems the data conversion is not hard. But we have hundreds of dbase programs that need to be converted to foxpro ones....
4
4818
by: Robert Bravery | last post by:
HI all, Can someone show me or point me to a place where I can find out how to update dbase(dbf) tables. Thanks RObert
0
1239
by: jessejames | last post by:
I need to update multiple record in my table(in PostgreSQL dbase).. here is my sample data user_id user_name display_name email_address 1 user1 BPI bpi.com 2 user2 Union union.com 3 user3 WestBank westbank.com i want to...
5
3222
by: abhilashcashok | last post by:
hi guys, my prblem is that I cannot update sql query against MS ACCESS using C#. Everytime wen i do so, i got an exception (at runtime) as 'UPDATE syntax not correct'. I don find any error in my 'update' syntax. I can successfully run other dbase operations like insertion, deletion & all.; except Updation. But, i can successfully run the...
2
11123
by: bcbrock | last post by:
I am trying to figure out how to query some data out of a dbase IV (.dbf) file sitting on a remote server from my MySQL/PHP/Web Server. Both servers are Windows Server 2003 SP2. My MySQL/PHP/Web server is running PHP 4.3.11, MySQL 4.0.24, and IIS. I have set a system DSN on the remote machine for the directory that contains the dbase...
1
3933
by: JFB | last post by:
Hi, I have a connection to a dbase IV file using oledb. I wan to do an update to a field using a vb function passing two parameters. These 2 parameters are fields from the same table. What is the sintax to do this? Thanks JFB ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
0
7393
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7803
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7749
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
4942
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3444
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3439
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1871
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1012
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
695
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.