When users created new table, they automatically have access to it right.
But when we give SELECT access on the same database for other users; this means they can also access the same new table created by other user.
How can we separate the access that only user who created the table will have access to it?
Just to be clear if this will be my scenario,
I will create a new user with CREATE rights only.
He will have SELECT access to all other table while having DML (CREATE) access to objects user will create.
A user with only the CREATE TABLE right will get all rights (DDL & DML & DCL) on the tables he creates, but is not able to access any other object in any way.