May 26, 2007 at 12:39 am
I have Two tables in these table i can access only one table,permission only.
know
using view i can insert data into two table is it possible or not
or
using storedprocedures to insert the data into the table is it possible any give some good solution to these things.
NOTE:-I have permission only on one table.
Thanks & Regaurds
shiv
May 28, 2007 at 1:40 am
You can use a proc to insert data into a table that you don't have perms to insert to directly if you have perms to execute the proc.
that's one of the main reasons to use procs: you can deny access to the tables directly and allow access only indirectly, through procs that the user has been granted exec on.
---------------------------------------
elsasoft.org
May 28, 2007 at 1:45 am
Thank u
I had sloved that prob,
I have new prob My db is monday full backup,
Everyday 10:00 clock diffbackup
every one hour transaction log backup
my db is crassed.
how can i restore the database
plz send
May 29, 2007 at 6:29 am
Search BooksOnLine for RESTORE DATABASE. If you have tried to restore the database, it didn't work, and you can't find answer in BOL, please ask again and specify what the problem is.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply