How to create a VIEW in SQL

Question

I have a user table and I need to create a VIEW so a user can only see their own data/row.

How could I achieve this? I have been searching online on how to create views but I can't find anything useful/explains well!! Please help!!

tUser with user_id, name, address

What do you mean with view? Do you want to display everything in a table via php or something simmular? — Robin
– Robin, Commented May 9, 2015 at 21:23

void · Accepted Answer · 2015-05-09 21:32:06Z

2

Only with having a field for user (id or name) you can make a view so that a user can see or manipulate only his/her data:

assuming your table is:

tbl (fld_1, usr,....) -- usr is for the the user who created the record

you can create your view as:

create view vw as
select * from tbl
where usr=current_user

edited May 9, 2015 at 21:32

answered May 9, 2015 at 21:23

void

7,9403 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gordon Linoff Over a year ago

This answers your question. If you have some other question about stored procedures (which doesn't seem relevant), then you should ask that as another question.

Satyanand bhardwaj · Accepted Answer · 2017-09-30 10:30:04Z

0

Create View As VeiwDemo
Select * 
From Your_TableName
Where UserId=UserId

edited Sep 30, 2017 at 10:30

user1773603

answered Sep 30, 2017 at 10:11

Satyanand bhardwaj

3653 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to create a VIEW in SQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related