Today I have accidentally given access to a user using the grant option by issuing the Grant sql command.
GRANT VIEW ANY DATABASE TO username;
I have immediately realised that I didn't want to give access to that user and hence I had to revoke the permissions.
REVOKE VIEW ANY DATABASE From username;
Thought I would document this here so that any one doing the same would benefit from this.
Also there is a With Grant option that you can use while using Grant option.
The main difference between Grant and With Grant option is that --
If only GRANT is used, the user cannot grant the same permission to other users.
At my work I have inherited a database where the partitioning was not done correctly. This database holds millions and millions of records...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...