How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask LogicPro Your Own Question
LogicPro
LogicPro, Engineer
Category: Homework
Satisfied Customers: 12870
Experience:  Expert in Java C++ C C# VB Javascript Design SQL HTML
29751445
Type Your Homework Question Here...
LogicPro is online now
A new question is answered every 9 seconds

Password protect the database. (I have the database) Create

Customer Question

Password ***** the database. (I have the database)
Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database.
Create at least two different users and implement their permissions using SQL statements.
The steps you took to password ***** the database
The matrix
The SQL code for creating the users and implementing their permissions
Submitted: 1 year ago.
Category: Homework
Expert:  LogicPro replied 1 year ago.

Hi,

Welcome

Hope you are doing well.

Please elaborate.

Zip all files; upload the zipped file to http://wikisend.com or http://ge.tt and post download link here.

What is the deadline?

Customer: replied 1 year ago.
I'm using Microsoft Access for my database, I just need these few things listed below to work in my database
My deadline is tomorrow night or early Sunday Morning. (Pass words you use, make it simple)
Password ***** the database you created for your individual assignment in Week Three.
Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database.
Create at least two different users and implement their permissions using SQL statements.
Submit the following deliverables to your instructor:
• The steps you took to password ***** the database
• The matrix
• The SQL code for creating the users and implementing their permissions(How do i need to send my database?)
Customer: replied 1 year ago.
Here is my Zipped file
Expert:  LogicPro replied 1 year ago.

Please wait. let me review

Customer: replied 1 year ago.
Ok
Customer: replied 1 year ago.
No phone calls
Expert:  LogicPro replied 1 year ago.

I don't find a way to create user and permissions using sql for MS Access database

It can be done in MS Sql Server/Oracle. In Access, we can put the database in a folder and provide permissions to user group

Expert:  LogicPro replied 1 year ago.

Let me know if you have database in SQL Server or oracle

Customer: replied 1 year ago.
Ok, that will be fine to put the in a folder, will this work?
Expert:  LogicPro replied 1 year ago.

It says "Create at least two different users and implement their permissions using SQL statements"

If it is put in folder, we will need to work with Windows security

Customer: replied 1 year ago.
I just googled, it will work
Customer: replied 1 year ago.
If you want to delete any thing in the database you can, just keep all of my tables
Expert:  LogicPro replied 1 year ago.

Let me opt out for other experts to answer as I am out of ideas for this one

Please wait. You will be notified by email as soon as any Professional joins you.

I would be happy to help you with your other questions though.

Thank you for your patience.

Customer: replied 1 year ago.
I have SQL Server, can you still assist?
Expert:  LogicPro replied 1 year ago.

Just saw the message. Yes, if you are using sql server, I can help

Customer: replied 1 year ago.
I'm using SQL server 2012
Expert:  LogicPro replied 1 year ago.

ok. Let me know the name of your database in MS SQL Server. I will write sql to create 2 users and grant previlages

Customer: replied 1 year ago.
Take the file that I sent and convert it to SQL server just the tables.
Expert:  LogicPro replied 1 year ago.

ok

Customer: replied 1 year ago.
What is the time frame you will have this done?
Expert:  LogicPro replied 1 year ago.

It will take time.

Looking at the efforts, I am sending small revised offer. let me know once you accept it.

Expert:  LogicPro replied 1 year ago.

Somehow I cannot sent

Expert:  LogicPro replied 1 year ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.